Date/Time Query

[jeanmarc]

Hi,

I need to query a table to obtain a count on the number of records created and/or modified after a certain time e.g. 18:00:00 PM.

Select COUNT(X)
from my_Table
where created_date < a_specifc_time
or modified_date < a_specific_time

I'm used to Oracle and a newbie on Accesss.

Thanks to have the correct syntax for the above query.

Regards
JM

 

[DCrake]

If your date field is stored in date/time format, ie dd/mm/yyyy hh:nn:ss then you can use

<= 02/02/2009 18:00:00

You will need to include a date as well as it is all part of the field.

 

[jeanmarc]

Hi DCrake,

Thanks for your response.

I've specified the date as long date format.

Unfortunately, i can't specify the exact date since i need the statistics for 1 month.

Any workaround?

THanks
JM

 

[DCrake]

Ok so create a query based on the table and add a field that extracts the time element form the date field

t:Format([YourDateField],"hh:nn")

Then use a condition to limit it to after 6pm.

David

 

[jeanmarc]

Thank DCrake.

Implemented your solution. it works.