How to convert date to a number (special)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

galsaba - 22 May 2005 20:17 GMT

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

Reply to this Message

Ofer - 22 May 2005 20:40 GMT

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"))

> 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
[quoted text clipped - 3 lines]
>
> galsaba

Reply to this Message