Unable to insert today's date in access, 12 May is taken as 5 December

[ravidcurious]

I have an access database with a query which inserts system date/time from Now() function to a column. My system date is 12-05-14 (12 May 14) and when it is inserting in the table is taken as 05-12-14 (5 Dec 14). Can anybody help me to get it resolved?

Thanks in Advance !

 

[bob fitz]

see: http://allenbrowne.com/ser-36.html

 

[ravidcurious]

Thanks Bob. Its really helpful.