Date-1 Criteria In Query

**RAJESHKUMAR R** · 05-14-2018, 04:32 AM

Dear Experts,

I have below criteria in one of my Query to pull out data from a Table.

Code:

>=[Forms]![MENU]![FR_DATE] And <=[Forms]![MENU]![TO_DATE]

For an Example, FR_DATE is 01 May 2018, TO_DATE is 09 May 2018. Above criteria pull out all data between these two days!

The support I am looking here is, I would like to modify the criteria which pull out all data from FR_DATE i.e. 01 May 2018 and always TO_DATE-1 i.e. in this case it is 08 May 2018!

Thanks & Regards,
Rajeshkumar R

**Minty** · 05-14-2018, 05:02 AM

Simply subtract 1 day? or use less than instead of less <=

Either >=[Forms]![MENU]![FR_DATE] And <[Forms]![MENU]![TO_DATE]
or
>=[Forms]![MENU]![FR_DATE] And <=([Forms]![MENU]![TO_DATE] -1)

**RAJESHKUMAR R** · 05-14-2018, 07:06 AM

Dear Minty,

Tanks for your instant Response, it helped me a lot!

Thanks & Regards,
Rajeshkumar R

Date-1 Criteria In Query

Thread Tools

Date-1 Criteria In Query

Similar Threads

Query by date criteria help

Query Date Criteria, using multiple column data within one criteria

DateAdd in Query Criteria to display a date in a field 2 days prior to the date in another field

Query Help Please - Criteria: <Date()+90 And >Date() Or: <Date()+90 >[Date Data]

Query Date Criteria

Posting Permissions