How to convert date to a number (special)

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert date to text 2
Problem formatting dates from CSV file 2
Change font color in a report field 3
Converting a non recognizable date time 1
How to enter start and end date/time in excel based on some specific value. 7
Converting a Date Question 2
Special string convertion to date and time 4
Special converting of string date&time to date format 3

Top