Database table - Converting Date to Number

Question

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?

braX · Accepted Answer · 2018-01-23 16:21:12Z

1

You can use the format command like this:

=Format$(Date, "ddmmyyyy")

answered Jan 23, 2018 at 16:21

braX

11.9k5 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

acr_scout Over a year ago

This will leave the data as a date type. If you want to store the information as a number you will have to convert it to a number, but if you do, it will remove any leading zeros. The other option is to change the formatted date type to a string type possibly using cstr

Collectives™ on Stack Overflow

Database table - Converting Date to Number

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related