How to have a fixed time populated in a date/time formula field?

Question

I have to create a date/time formula field, whose date value will come from a date/time field. However, I want the time to be always 5:00 am. How do I achieve that?

Answer 1

You can try this formula:

DATETIMEVALUE(TEXT(DATEVALUE(CreatedDate))+ ' 05:00:00')

Where CreatedDate is your DT field. This will be in GMT though, so you have have to adjust for your time zone.