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?

Paul Kissick · Accepted Answer

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.

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

One Answer

Add your own answers!

Ask a Question