access dates and times

M

mr me

Hi Everybody,

I have a month trying to programmatically store today's
date in access table with [mtoday] = Date()but all in vain.

After I hit return key Date() automatically turns into
date and gives undesired results.

how do i store today's date and be able to use Date() and
Time() functions in Access 2000.

Please help
 
Top