0

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?

1 Answer 1

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.

3
  • Mine is GMT -7, how can I adjust that? Oct 5, 2020 at 17:35
  • 1
    Try DATETIMEVALUE(TEXT(DATEVALUE(CreatedDate))+ ' 05:00:00') - (7/24) Oct 7, 2020 at 13:22
  • For GMT + 5:30, DATETIMEVALUE(TEXT(DATEVALUE(CreatedDate))+ ' 05:00:00') +(5.30/24) is it the right adjustment? –
    – Rockstar
    Nov 3, 2021 at 10:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .