Between Date AND Time Parameter Query

[EdwardsC]

I can set up a parameter query to filter between dates but is there a way to filter between dates & times I.e 06/26/22 08:00:00 AM to 06/27/22 08:00:00 PM?

 

[CJ_London]

yes - the same way - if your date and time fields are separate, then just add them together

 

[The_Doc_Man]

A Date field holding only a date is merely a Date field for which the fraction has been removed - because the fraction represents time of day in the same field.

 

[arnelgp]

I can set up a parameter query to filter between dates but is there a way to filter between

yes you can and i don't think you need to separate the date and time components to another field.
but don't use Between in your criteria.
use, this format for your criteria:

>=[StartDate] And <=[EndDate]

and you must type Exact format as you have on the date field.