How can I concatenate a fixed Day to a Date


Hi, Need some help.


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.



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


Thank you so much.
It worked perfect.

Had to add an “s” for months.