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

  • Thread starter Thread starter Steve P
  • Start date Start date
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!!!
 

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
Date issue in Access 2007 SQL 4
Removing fields from table 3
calculating value in a query 1
Combining records by date 1
anther date question 4
service pack 1 update 6
Report to Filter on Next Date Per File 2

Back
Top