[thelist] Inserting dates and booleans into MS Access
Tim Burgan
email at timburgan.com
Wed Jan 19 07:11:02 CST 2005
Hi Jay,
Jay Blanchard wrote:
> What is the date format that Access (you can look in the table design
> screen of Access) is expecting? And on the checkboxes, have you
> echo'ed
> out what they return to the screen so that you can see it? Have you
> echo'ed your query to the screen so that you can see it?
The date format within Access is actually left blank. I can see that
there are the options of: general data, long date, medium date, short
date, long time, medium time, short time.
Just by looking at it - medium date is closest to what I'm looking for.
I just tried it by doing:
strftime("%d-%b-%y", mktime($month,$day,$year));
// which returns 20-Jan-05 .. the medium date format required by Access
IT NOW WORKS. I didn't actually realise that I had to set the "format"
within Access, because the interface within Access leads you to believe
that you can enter any date in any format.
Thanks for your help.
Tim
More information about the thelist
mailing list