Date Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date format, 20051201, what is the formula to convert to 12/02/2005
 
What's the value stored in: a number, or a string?

For a string, try DateSerial(Left$(DateField, 4), Mid$(DateField, 5, 2),
Right$(DateField, 2))

For a number, try CDate(Format(DateField, "0000\-00\-00"))
 
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

Using DateAdd and IIF conditions in a Query 2
advanced filter 1
How to get largest date from a Vlookup 1
Dlookup 7
Converting Date to Julian 4
Which is the best MBOX Converter Tool different formats conversion? 5
Formulas 2
Need help with access expression - HELP!! 0

Back
Top