Skip to main content
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") )
 

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

Reply


Terms & Conditions