Help to format Date

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

Guest

I have a field with numbers like 12122000. I need to format this into the
date format mm/dd/yyyy, 12/12/2000. What is the best way to accomplish this?
 
pokdbz said:
I have a field with numbers like 12122000. I need to format this
into the date format mm/dd/yyyy, 12/12/2000. What is the best way to
accomplish this?
Click to expand...

For a string that looks like you want...
=Format([FieldName], "00/00/0000")

If you want the output to be an actual date DataType...
CDate(Format([FieldName], "00/00/0000"))
 

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

convert date 1
Help with date query 3
Forcing a date entry format of dd/mm/yyyy 1
Formatting date gives bad results in query 2
Preserving date format 2
Form Control Calendar date will not change its format 1
date format convert 2
How to enter a date in DD-MM-YYYY format 2

Back
Top