Convert date to year month day

[staceyn]

I have a field that has the date entered as MM/DD/YYYY. I need to set up a new field that will convert it to text with YYYYMMDD. Can anyone help me with a calculation?

Thank you so much.

[bcooney]

Using a different date format is not an option? Layout Mode > Format Date (field must be selected).

[Lee Smith]

If I'm understanding what you want (i.e. 11/29/2007 to 2007/11/29)

Try this

New Field (Calc, Text) =

Year ( [color:blue]YourDate ) & "/" & Month ( [color:blue]YourDate ) & "/" & Day ( [color:blue]YourDate )

Substitute your [color:blue]date field for [color:blue]YourDate

HTH

Lee

p.s. let us know if this doesn't do what you want.

[MarkWilson]

Year( DateField ) & Right( "0" & Month( DateField ) , 2 ) & Right( "0" & Day( DateField ) , 2 )