dates in Access

hi....
can u please explain me as to how to handle Date data type in Access..
each time it gives a different..i mean that its not clear to me whether days or months come first..
thanks....

Hi,

You can use # character to enclose dates. like #01/22/2006#. In this way, month comes first always.

Please verify this because I worked with MS Access long back and with older versions.

Regards

Kish.