Reputation: 1090
I am trying to convert a date to a number.
I need to have in my table a field with default value based on a date.
So if today is 23/01/2018, I want to have a number look like this 23012018.
Any ideas?
Upvotes: 1
Views: 36
Reputation: 11755
You can use the format command like this:
=Format$(Date, "ddmmyyyy")
Upvotes: 1