ODBC error?

[chriss1519]

I am running a query off an ODBC datasource. One field in the query is a formula which extracts the year out of a julian date (the formula is: mid(juldate,3,1)). I also set up a criteria for this field, where I want it to select only records for 2004. When I try to run this query, I get this message:

ODBC --call failed
OK

When I take the criteria out for this field, so that I am pulling all years, the query works.

Anyone know any work arounds for this, or why this is happening in the first place.

 

[SydneyGeek]

Chris, just wondering -- does mid(juldate,3,1) give you a 4-digit or a 1-digit result? Looks like it would be 1 digit -- then, applying 2004 as a criterion would give you an empty data set.
Try mid(juldate,3,4)

Denis