Skip to main content

Thank you @ScottWorld for your assistance with the first part of the formula


While that fixed one issue - it introduced another issue


I know that the results are showing in my time zone, but I don’t want my time zone to be used - I want the client’s timezone (Pacific for the particular request)


You can use the DATETIME_FORMAT with SET_TIMEZONE to display a date/time in a specific time zone.


DATETIME_FORMAT(

  SET_TIMEZONE({Start Time}, 'America/Los_Angeles'), 

  'M/D/YYYY h:mma'

)

See the formula field reference for more info.

Hi @Ronni_Eloff,


You can write a formula that forces a time to Pacific Time Zone like this:


DATETIME_FORMAT(SET_TIMEZONE({Your Date Field}, 'America/Los_Angeles'), 'M/D/YYYY h:mma')

You can learn more about time zones with my sample base & training video here:


Lol, I didn’t see @kuovonne’s reply above because I was typing this on my iPhone — but great minds think alike! 😝

You can use the DATETIME_FORMAT with SET_TIMEZONE to display a date/time in a specific time zone.


DATETIME_FORMAT(

  SET_TIMEZONE({Start Time}, 'America/Los_Angeles'), 

  'M/D/YYYY h:mma'

)

See the formula field reference for more info.


I have already on formula so we can do the duration changes without having to manually calculate when the session will end. We have 6 hours of programming to program per event - So I want to be able to make a template base so the programming team can quickly do the multitude of event planning.


Currently on End Time we have:

DATEADD({Start Time}, {Duration}, ‘minutes’)


I do not see how incorporate


DATETIME_FORMAT(

SET_TIMEZONE({Start Time}, ‘America/Los_Angeles’),

‘M/D/YYYY h:mma’

)


on {End Time} and I have tried the standard excel formula style - first action (The adding on duration) goes first, then the modification of the time to set timezone would go second.


.

I have already on formula so we can do the duration changes without having to manually calculate when the session will end. We have 6 hours of programming to program per event - So I want to be able to make a template base so the programming team can quickly do the multitude of event planning.


Currently on End Time we have:

DATEADD({Start Time}, {Duration}, ‘minutes’)


I do not see how incorporate


DATETIME_FORMAT(

SET_TIMEZONE({Start Time}, ‘America/Los_Angeles’),

‘M/D/YYYY h:mma’

)


on {End Time} and I have tried the standard excel formula style - first action (The adding on duration) goes first, then the modification of the time to set timezone would go second.


.


You should create a new formula field. Your existing DATEADD formula calculates the end time, which is stored as a date object in GMT time under the hood. Create a new formula field with DATETIME_FORMAT to format that date object as a text string if the date/time in the desired time zone.


DATETIME_FORMAT(

  SET_TIMEZONE({End Time}, 'America/Los_Angeles'), 

  'M/D/YYYY h:mma'

)

Reply


Terms & Conditions