Convert date string (ie: 1/3/2010) to seriel

  • Thread starter Thread starter Steve P
  • Start date Start date
S

Steve P

How do i convert a date formatted like: 3/8/2010 (string) to its
corresponding seriel?
 
Use CDate.

? CDate("3/8/2010")
2010.03.08

( In my case, it took the first number as the month; my Regional setting
tell Windows to format my dates in the ISO format, which is year dot month
dot day ).


Vanderghast, Access MVP
 
Van,
Thats exactly what i needed. I just formatted it differently with:

Format([date],"mmddyyyy")

THANKS AGAIN!!!
 
You must log in or register to reply here.

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 do I join 3 separate columns of dates 6
Which is the best MBOX Converter Tool different formats conversion? 4
How to Convert MBOX to PST Online? 3
Date issue in Access 2007 SQL 4
Removing fields from table 3
Combining records by date 1
anther date question 4
calculating value in a query 1

Back
Top