Update a Datetime variable with particular hour value

Question

I need a datetime - yesterday 9 PM

I tried like below, but it is set as 12 AM only.

AddDays(Today(), -1) + (MakeTimeSpan(0, 21, 0, 0))

Answer 1

To set datetime to yesterday 9PM you can go with something like this

ToDateTime(AddDays(Today(),-1) & " " & MakeTime (21,0,0))