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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataGridView : How to Transform data between user input and validation ? 4
Counting Numbers 26
converting number data to text and formating 2
How do I change Text to a number format 2
Change Text format to Numbers format in a query 2
How to transform a cell value that as no comma like 43534 into 435,34 3
TRANSFORM X AND Y 3
Crosstab queries 5

Top