How can I concatenate a fixed Day to a Date


#1

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

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


#3

Thank you so much.
It worked perfect.

Had to add an “s” for months.

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