date function 1

[kripa]

updating the date to the ms access table from vb form.

in vb form the input is like 24/8/01 (date/month/year)
but while upating in access its saved as 1/8/24 24 is taken as year and 1 as day. the design of the date field is medium date. kindly suggest me the format to be done.

thanks

kripa

 

[tlbroadbent]

By default, Access works with the American date format - mm/dd/yy. Read the articles at the following links for great suggestions regarding date handling in Access.

http://www.dougdean.com/articles/How2Project6.htm

http://wa.apana.org.au/~abrowne/ser-36.html

http://support.microsoft.com/support/kb/articles/Q88/6/57.ASP

http://support.microsoft.com/support/kb/articles/Q185/4/80.ASP

Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[hardcoder]

Terry
Thanks a lot for this link

http://wa.apana.org.au/~abrowne/ser-36.html

It solved my prob in a minute!

Thanks again.
BTW, This looks like a great forum!

hardcoder