Help

Re: Concatenate with datetime formula adds 1 extra day

1593 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nedra_Hines
6 - Interface Innovator
6 - Interface Innovator

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.Capture2
Capture

5 Replies 5

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

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!!