Converting a date to text

[AliciaA]

Hi-

I have some dates that need to be converted into text to be used in a parameter query. It has to be in the format yyyy/mm/dd. I tried =TEXT(B2,yyyy/mm/dd), but that results in an error. I can't just chnage the formatting in B2 because I also have to be able to do math with that date.

Any suggestions?

Thanks
Alicia

[daddylonglegs]

With TEXT function you need quotes around the format, i.e.

=TEXT(B2,"yyyy/mm/dd")

[AliciaA]

Thank you!

The sad thing is that I've made that mistake at least twice before...

Alicia