How can I concatenate a fixed Day to a Date

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

Page 1 / 1

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}

Sign up