Help to format Date

P

pokdbz

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?
 
R

Rick Brandt

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