Share via

Serial number for a date in MS Access SQL

Anonymous
2019-01-18T23:01:03+00:00

Hello all,

I'm trying to get in MS access SQL the serial number (For "43483" for "01/18/2018") for a date. I tried various functions but none of them worked.

Any recommendations?

Thanks,

Al

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-01-18T23:17:52+00:00

Clng([datefield]) should do it. The date is actually stored as a Double count of days and fractions of a day (time) since midnight December 30, 1899.

Was this answer helpful?

2 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-01-18T23:29:46+00:00

    Clng([datefield]) should do it. The date is actually stored as a Double count of days and fractions of a day (time) since midnight December 30, 1899.

    Thank you!

    Was this answer helpful?

    0 comments