Forum Discussion
catsrock1023
Jun 01, 2021Copper Contributor
Return current date for year
I need some help building a formula. I need to return the current year of a date in a cell in the YYYY-MM-DD format. For example, in one cell I have 1997-11-10 and I need it to return 2021-11-10 in a...
SergeiBaklan
Jun 01, 2021Diamond Contributor
That's not Excel, that is this app https://generalcaster.app/website/documentation/formula/ which uses formulas as in Excel, but not all and by bit different way.
PeterBartholomew1
Jun 01, 2021Silver Contributor
Thanks. I had picked up that another system came into the picture but I (wrongly) assumed it was an import/export issue.