Help

How can I concatenate a fixed Day to a Date

Topic Labels: Formulas
946 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Toshitaka_Inoue
4 - Data Explorer
4 - Data Explorer

Hi, Need some help.

DATETIME_FORMAT(DATEADD({Date},{NumberMonths},‘month’),‘YYYY-MM’)

example:
Date = Jan 1, 2019
NumberMonths = 3

the result is 2019-04

if I have a value in the record table like
Day = 25

I want the result to be 2019-04-25
This is for a payment table that reminds me to pay on the 25th of the 3rd month from Jan. 1st.

Thanks

2 Replies 2

try DATETIME_FORMAT(DATEADD({Date},{NumberMonths},‘month’),‘YYYY-MM’)&"-"&{Day}

Thank you so much.
It worked perfect.

Had to add an “s” for months.

DATETIME_FORMAT(DATEADD({Date},{NumberMonths},‘months’),‘YYYY-MM’)&"-"&{Day}