Can anyone tell me what wrong i am doing while inserting date in into ms access?
I am inserting date using below sql statement and date format is d-M-yyyy
insert into tbl_date(date_value) values(#8/7/2014#)
It's not showing me any error but store in access 7-Aug-2014 instead of 8-Jul-2014
what is solution for this?
Thanks in advance.