Hey everyone! I’m creating a column in a table where I’m concatenating a date field (formula driven), client name and default text. The result of the concatenate is adding an extra day to the formula driven date. Below is the formula and I uploaded an image of the dates reflecting the additional day. Any insight on what’s causing this? It’s so weird!
Formula in the concatenate field: CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date},‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”)
Concatenate with datetime formula is adding an additional day
+8
+25The most likely answer is it having to do with timezones. Use the SET_TIMEZONE() function to force a particular timezone. The format would be something like
DATETIME_FORMAT(
SET_TIMEZONE({Monthly Rental Fee Renewal Date}, "America/Los_Angeles"),
"MM-DD-YY"
)
1 person likes this
+8Kamille_Parks11 wrote:
The most likely answer is it having to do with timezones. Use the SET_TIMEZONE() function to force a particular timezone. The format would be something like
DATETIME_FORMAT(
SET_TIMEZONE({Monthly Rental Fee Renewal Date}, "America/Los_Angeles"),
"MM-DD-YY"
)
Thank you! This is what I have and it isn’t working:
CONCATENATE(DATETIME_FORMAT(SET_TIMEZONE({Monthly Rental Fee Renewal Date}, “America/Chicago”),‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”)
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.