How to convert date to a number (special)

  • Thread starter Thread starter galsaba
  • Start date Start date
G

galsaba

I have a field - date. Let's say that one of the values is 6/20/05.
How can I convert it to a number field, for example 6/20/05
will be shown as 20050605?

Thanks,

galsaba
 
You should use the format function

format(MyDate,"yyyymmdd")

and then you can change it to a number format
' to long format
clng(format(MyDate,"yyyymmdd"))
' to double format
cdbl(format(MyDate,"yyyymmdd"))
 
Back
Top