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?
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.
-
-
1Try DATETIMEVALUE(TEXT(DATEVALUE(CreatedDate))+ ' 05:00:00') - (7/24) – Paul Kissick Oct 7 '20 at 13:22