make today's date with the specified date

Question

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 InvoiceOutput2002-08-292021-08-092008-10-092021-10-092010-11-202021-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 Answer

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