
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 12, 2023 07:42 PM
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 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 15, 2023 02:17 AM
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} ?
