Hey Gio,
Can you please share the documentation that outlines the formatting syntax within the technical expression editor?
For example, for the function FORMAT_DATE_TZ(), the fields within the function are FORMAT_DATE_TZ( [Source] , [Format] , [Timezone] ). In the [Format] field, what are all the shorthand syntax codes in this section.
Date:
MM/DD/YYYY = 09/17/2020
MMM = Jan
Time
HH:mm = 14:03
hh:mm = 12:03
etc…
Hey @Esinger5,
Thanks for reaching out!
The formats that are applied when using the FORMAT_DATE_TZ() function use the same nomenclature as can be found here: https://devhints.io/moment.
Let me know if that’s what you were looking for and if you have any other questions!
Gio
What arguments are allowed for the TIMEZONE parameter? the link provided doesn’t seem to cover this part. Wondering if there are ways to include or exclude daylight savings time, for example.
@jmlowden this article may help a bit Using Datetime Expressions - not sure about if there are ways to include or exclude daylight savings, however