make today's date with the specified date

[Ar13f]

Dear All,

if I change the date as in the output column taken from the next column, what is the formula? (the year changes to 2021 but the month and date are the same)

Date Invoice	Output
2002-08-29	2021-08-09
2008-10-09	2021-10-09
2010-11-20	2021-11-20

I tried to construct the year, but I couldn't figure out how to add the month and day. Perhaps you have a better formula than I do. Thank you in advance.

[danilang · Accepted solution]

Hi @Ar13f 

You can use ToString(DatetimeYear(DateTimeToday()))+Substring([Date Invoice],4).  Just watch out for leap years.  2008-02-29 is a valid date, but 2021-02-29 isn't.  You'll have to decide what to do in these cases.

Dan

[Ar13f]

Dear @danilang 

I hope you and family in good health ...

thank you for your advice .... 

regards,

Arief