Skip to main content

Combined Date & Time field issue with Time Zone / GMT

  • November 13, 2023
  • 1 reply
  • 16 views
D
Forum|alt.badge.img+6
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") )
 

1 reply

Databaser
Forum|alt.badge.img+25
  • Databaser
  • Brainy
  • November 15, 2023

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} ?
Jan - Databaser
Terms & ConditionsAccessibility statement