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.
Solved! Go to 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
Dear @danilang
I hope you and family in good health ...
thank you for your advice ....
regards,
Arief