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

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
AutoNumber 2
Change font color in a report field 3
How to find Minimum of four fields 11
Form from two tables 1
Converting a non recognizable date time 1
Windows 7 I need to convert date to text 3

Back
Top