Problems with date query 1

[Appollo14]

Hi,

I'm getting some strange results with a date query that i'm using. Sometimes it will display the correct results sometimes not. At times i have to use a months date range just to get anything at all to display.

The query i'm using is;

stLinkCriteriaMain = WHERE & " [tbJob].[OrderDate] >= #" & Me.txtDateFrom & "# And [tbJob].[OrderDate] <= #" & Me.txtDateTo & "#"

Any ideas where i'm going wrong?

Regards,
Noel.

 

[RoyVidar]

Guessing your regional settings date format differs from US?

Try:

[tt]" [tbJob].[OrderDate] >= #" & format$(Me.txtDateFrom, "yyyy-mm-dd") & _
"# And [tbJob].[OrderDate] <= #" & format$(Me.txtDateTo, "yyyy-mm-dd") & "#"[/tt]

See International Dates in Access for more info.

Roy-Vidar

 

[Appollo14]

Thanks Roy, that seems to have done the trick.

Regards,
Noel.