How to transform a data into a number, but not as julian number

M

Marco

Hi. I have adate and I would like to transform it in a number. Ir order a
query ready this number a use it as a criteria.

I have 21-02-2008 and I need to transform in 20080221

is it possible? I tried like: =righ([Data_Fim];4) & Mid([Data_Fim];4;2) &
Left([Data_Fim];2)


Regards,
Marco
 
Top