Datetime_format() showing wrong day

Hunter_Reynolds · ‎Oct 22, 2020

Hi. I’m trying to use DATETIME_Format() inside of a formula field to display the day in which an order was placed.

These are the dates of the orders. For reference, the 18th took place on a Sunday.

The formula block is a very simple DATE_FORMAT() function, showing the day. However, it seems as if the date format is incorrect and is defaulting to GMT time (adding 4 hours to the time fields, causing the time to roll over to the next day). I don’t know how to fix this, and I can’t change it because under formatting it says:

Can someone please help?! Thanks

Justin_Barrett · ‎Oct 24, 2020

Hunter_Reynolds:

when trying to change the static “America/New_York” value inside the SET_TIMEZONE() node with the Dynamic “America/New_York” from the table, it seems to break. Any ideas?

My Dynamic Formula:
IF(AND(HOUR({Proper Date Created}) >= {GMT Midnight Time}, HOUR({Proper Date Created}) <= {GMT Club Close Hour}),
DATETIME_FORMAT(SET_TIMEZONE(DATEADD({Proper Date Created}, -1, "day"),
"{Official Time Zone of Event (from Timezone) (from What Club?)}"), 'dddd'), DATETIME_FORMAT(SET_TIMEZONE({Proper Date Created},
"{Official Time Zone of Event (from Timezone) (from What Club?)}"), 'dddd'))

SET_TIMEZONE() requires a string representing the name of the desired timezone. However, you’ve put quotes around the field reference, which turns it into a literal string representing name of the field. Text fields (long and short) already return strings, so just nix the quotes around the field name.