Toshitaka_Inoue - profile

Toshitaka_Inoue · Jan 17, 2019

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 fo...

Toshitaka_Inoue · Jan 17, 2019

Thank you so much. It worked perfect. Had to add an “s” for months. DATETIME_FORMAT(DATEADD({Date},{NumberMonths},‘months’),‘YYYY-MM’)&"-"&{Day}

User Statistics

User Activity

How can I concatenate a fixed Day to a Date

Re: How can I concatenate a fixed Day to a Date