Hi -

I recently moved to WIndows 7 from windows XP and am experiencing some odd behaviour with regards the database I am using.

Specifically, the interpretation of the date on the 2 versions of windows seems to be causing problems.

I am using Firebird 2:0 and IBExpert (latest versions.)

ON the XP machine on the same database - this query works (returns data.)

SELECT TRANSID,TRANSDATE,INTERNAL_REF,DELIVERYITEM,ARCHIVED from INVOICE WHERE INVOICETYPE = 'INVOICE' AND (TRANSDATE BETWEEN :ThisDate and :ThatDate) ORDER BY TRANSID DESCENDING;

ON the WIndows 7 machine (using the same database and same software) the same statement does not return any rows.

I have checked the Display format and regional-specific settings in the Windows control panel and it all seems correct a.

Any help would be much appreciated.

Thanks.

Dave.