Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date field that shows the date in this format - 22/09/2021
I need to add 5 hours and 30 minutes to my date.
My resultant date should look like the same, just I need to add 5 hours and 30 minutes to 22/09/2021.
Could be this:
Timestamp((YourTimeStamp + Timestamp(MakeTime(5,30))),'DD/MM/YYYY hh.mm.ss')
Or
TIMESTAMP(YourFieldName+Time#('05:30:00','hh:mm:ss'))