DATEADD + 45 days

[Michal_Kuczma]

hello,
I have a DATE column and would like to display date+45 days in another column. How to do that? I believe it has something with dateadd but don’t know how to use it properly

[Nick_Dennis]

Hi @Michal_Kuczma,
You are correct, this can be done with DATEADD(). The syntax looks like this:

DATEADD( {DATE}, 45, 'days')

Also make sure the formatting is consistent on both fields. Hope that helps!

[Michal_Kuczma]

but how to incorporate column name with date field here?

[Nick_Dennis]

Replace {DATE} in this formula with your own date field.

[Michal_Kuczma]

not working

DATEADD( {{column-name}DATE}, 45, ‘days’)

[Nick_Dennis]

DATEADD( {column-name}, 45, ‘days’)

[Michal_Kuczma]

DATEADD( {column-name}, 45, ‘days’) - invalid formula. Could you first try if its actually working? :winking_face:

[Nick_Dennis]

The formatting of the apostrophes might have gotten messed up here. Try copying this: 'days' (instead of ‘days’)

[Michal_Kuczma]

Nick_Dennis:

DATEADD( {column-name}, 45, ‘days’)

OK its working now;) Thanks a ton

I try to customize the output to get only date without time in the format D/M/YYYY

DATEADD( {column-name}, 45, ‘days’, ‘D/M/YYYY’) does not seem to work properly