A
AngieSD
I have a clients who's dates in thier database are all stored as numbers
formatted YYYYMMDD (always 8 characters) I would like to run a query from a
form with the date parameter entered by the user as a date then convert it in
the query as the number format needed. I can convert the number to date with
DateSerial but I don't know how to convert the date to number with the
correct format.
Thanks!
Angie
formatted YYYYMMDD (always 8 characters) I would like to run a query from a
form with the date parameter entered by the user as a date then convert it in
the query as the number format needed. I can convert the number to date with
DateSerial but I don't know how to convert the date to number with the
correct format.
Thanks!
Angie