I'm replacing a Visual Basic program that queries access with a perl program. The program isn't the issue...I don't think, since I do not have the source for the VB program.

Anyway...

when the VB produces the data file the date/time is in the
following format : mm/dd/yyyy hh:mm xM (ie 01/01/2010 10:00 pm)

when I execute the same query (at least I think it is), my date/time is in the
following format : yyyy-mm-dd hh:mm (24h) (ie. 2010-01-01 22:00)

I use the following format in my query's where crietera (table.datefield > #mm/dd/yyyy#),

I ran the VB script and the perl script on the same database.



It's possible, the VB program reformats the date into mm/dd/yyyy after
it's received from Access, but again, I don't have the source, so I don't
know.

Any ideas?