Hi all,
I have 140,000 rows of data, consisting of a "General Date & Time", plus 3 other number fields.
Is it possible to have a query extract just the date alone from the general date, and also extract the time too?
My table is laid out as
Gen_Date Number1 Number2 Number 3
12/02/2010 05:54 1.125 1.654 0.437
I tried something like Cal_Date: Date([Gen_date]), or GetTime: Time([Gen_date]) but I know I don't have the syntax quite right.
Many thanks
I have 140,000 rows of data, consisting of a "General Date & Time", plus 3 other number fields.
Is it possible to have a query extract just the date alone from the general date, and also extract the time too?
My table is laid out as
Gen_Date Number1 Number2 Number 3
12/02/2010 05:54 1.125 1.654 0.437
I tried something like Cal_Date: Date([Gen_date]), or GetTime: Time([Gen_date]) but I know I don't have the syntax quite right.
Many thanks