Query Criteria Using Date Range

[DBFIN]

I've created a simple query where I'm trying to extract only records with transaction date less than or equal to 9/1/2008. The query criteria asks for records where the transaction date is less than a form textbox date.

The query outputs records that do not meet the criteria. Why ?

<= [Forms]![SELECT REPORTING DATES]![box_transdate]

 

[HiTechCoach]

Since we can not see the data, we can not see the issue.

Please explain what is incorrect with the results. In what ways does the results not meet the criteria?


Are you maybe missing all records for the last day ( are you getting < not <=)?

 

[DBFIN]

Sometimes the solution is so simple that I miss it. "<= date" is not correct syntax in access. I changed it to "< date or = date". The query works fine. Thanks again for your help. I greatly appreciate it.

 

[boblarson]

When you say 9/1/2008 does that mean to you September 1st or January 9th? It can make a big difference when working with Queries as you normally need to format the dates for queries into U.S. Date format (where 9/1/2008 is September 1st).

 

[GT_engineer]

How do you format your queries to US format or otherway around

I have my dates going in as day/month/year but the query results comes out as month/day/year.


my SQL is

"Select * From View_Report_Job_List Where SaleDate >= #" & Date1 & "#"

Date 1 is input from user in format day/month/year