Trunc Date - using MS Access Passthrough to Oracle 1

[IngDep]

Not receiving any records when using the following in the WHERE section of the passthrough query in MS Access to extract data from an Oracle database.

Any insight as to the problem?

AND trunc(Min(CLAIM.CLCL_SVC_DT)) between to_char('01-JUN-08','DD-MM-YY') and to_char('02-JUN-08','DD-MM-YY')

 

[jimirvine]

Do not compate dates to strings

Your where clause should be

AND trunc(Min(CLAIM.CLCL_SVC_DT)) between to_date('01-JUN-08','DD-Mon-YY') and to_date('02-JUN-08','DD-Mon-YY')

(Provided CLAIM.CLCL_SVC_DT is a date datatype)