dates to number

[wdbouk]

I am wondering if I have a column of dates that I want to transfer to numbers (like excel) is it possible to so with access. My file is large and I can't transfer to excel to do the date conversion.
Thx

 

[PHV]

Which number ? Number of days since 1899-12-30 ?
SELECT CLng([your DateTime field]) As NumberOfDays
FROM yourTable;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wdbouk]

I wrote the following query

SELECT CLng([date_acquired]) AS NumberOfDays
FROM [Trading volume];

and i received a conversion error and the column of number of days was empty. The problem is not solved.

 

[PHV]

What is the datatype of date_acquired ?
Have you tried to play with the CDate function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wdbouk]

it was text. everything works fine now after converting the type to date/time