Help

Combined Date & Time field issue with Time Zone / GMT

Topic Labels: Formulas
812 1
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Allen-Hu1
6 - Interface Innovator
6 - Interface Innovator
Currently I have a Date & Time (duration) field.  I have combined them into 
 
The combined date & time formula is showing a different time zone it seems?  I want it to be Los Angeles.  Is there a way to do this?

"COMBINED START DATE & TIME" FORMULA:
IF( ({All Day Event}), DATETIME_FORMAT({Start Date & Time}, "MM/DD/YYYY"), DATETIME_FORMAT({Start Date & Time}, "MM/DD/YYYY HH:mm") )
 
Screenshot 2023-11-12 at 7.42.08 PM.png
1 Reply 1

If you change your Start Time field to a single line text type, you can use this formula:

 

 
IF({All Day Event}, CONCATENATE(DATETIME_FORMAT({Start date}, "MM/DD/YYYY"), " ", DATETIME_FORMAT(DATETIME_PARSE({Start time text}, "HH:mm"), "HH:mm"))
 
What formula are you using in {Start Date & Time} ?