Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Combined Date & Time field issue with Time Zone / GMT

Topic Labels: Formulas
916 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
Databaser
12 - Earth
12 - Earth

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} ?