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?

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
3
  • Mine is GMT -7, how can I adjust that?
    – Shobhit Saxena
    Commented Oct 5, 2020 at 17:35
  • 1
    Try DATETIMEVALUE(TEXT(DATEVALUE(CreatedDate))+ ' 05:00:00') - (7/24)
    – Paul Kissick
    Commented 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
    Commented 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 .