Skip to main content

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”)



Formula in the original date field (correct): DATEADD({Staging Date},32,‘days’)



Two screenshots are provided: One with the correct dates and the other with the dates that include an additional day.


look into the set timezone formula!

look into the set timezone formula!


Thank you! This is what I have and it isn’t working (I get an error):


CONCATENATE(DATETIME_FORMAT(SET_TIMEZONE({Monthly Rental Fee Renewal Date}, “America/Chicago”),‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”)

Thank you! This is what I have and it isn’t working (I get an error):


CONCATENATE(DATETIME_FORMAT(SET_TIMEZONE({Monthly Rental Fee Renewal Date}, “America/Chicago”),‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”)


DATETIME_FORMAT(SET_TIMEZONE(Expiration,‘America/Chicago’),‘MM-DD-YY’)&’ | ‘& Name&’ | '&“RENTAL FEE RENEWAL DATE”

DATETIME_FORMAT(SET_TIMEZONE(Expiration,‘America/Chicago’),‘MM-DD-YY’)&’ | ‘& Name&’ | '&“RENTAL FEE RENEWAL DATE”


OMG I tried it again and it worked!!! Thank you so much!!

OMG I tried it again and it worked!!! Thank you so much!!


just silly syntax rules

Reply


Terms & Conditions