YvetteLee
YvetteLee

Reputation: 1090

Database table - Converting Date to Number

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

Answers (1)

braX
braX

Reputation: 11755

You can use the format command like this:

=Format$(Date, "ddmmyyyy")

Upvotes: 1

Related Questions