Ok here's my question.
I have a large access database and i'm accessing it using pear.
This database has date fields that I need to be able to do a query of something like selecting all fields with a date > 10/01/2002 for example.
Right now access converts it to a formated date, I just want a number something like 20021001 for the above date this way I can easly compare to get records with the dates I want. Or is there any other way to do this?
If I can't do this with pear how would I do it otherwise? Seeing as I don't really need to use pear for this.
Thanks for any help, i'm pretty much stuck on this problem right now =(
-Blake