Need help formatting dates

[MyIronLung]

I need to format a date feild which has dates like:

5/9/2000
12/1/2000
3/12/2001
12/24/1999

to be in the form:
YYYY/MM/DD

I would like to do this with one update query.

Thanks,
MIL

 

[Databaseguy]

In the update to field:

=format([your field name],"YYYY/MM/DD&quot

 

[MyIronLung]

I tried that and it didn't work for some reason. Any other thoughts?

Thanks,
MIL

 

[gwinn7]

Try this in your debug window (Ctrl-G) without the quotes.

"? format("4/5/2001","YYYY/MM/DD&quot"

If this fails, then there is definitely a problem with one of your VBA components. If not, then could you explain the result you are receiving?

Thanks,
Gary
gwinn7