J
JBad
I have to retrieve a list of people whose passports have expired. I have the
list in the access database. Im trying to write a query to filter out those
ppl whose passport has expired since last 30 days from current date and also
those ppl whose passports would be expiring in the next 30 days from current
date. I cant seem to get the data types in dates to match. Can any one help
out please? the passport expiry dates are in the format mm/dd/yyyy and so is
the system date (under regional settings). Im trying to use date() /
formatdate() / cdate() but cant work it out...help!
Tanks..
list in the access database. Im trying to write a query to filter out those
ppl whose passport has expired since last 30 days from current date and also
those ppl whose passports would be expiring in the next 30 days from current
date. I cant seem to get the data types in dates to match. Can any one help
out please? the passport expiry dates are in the format mm/dd/yyyy and so is
the system date (under regional settings). Im trying to use date() /
formatdate() / cdate() but cant work it out...help!
Tanks..