Now() and Short Date format

[Kenln]

I set a date variable to Now(). It stores the date and time. Is there anyway to have it only store the date itself.

Visually this is not a problem. But when the users edit the field it shows the date and time.

Thank you,

 

[MarkK]

You can get only the date part if you use the Date() function instead of Now(). Also, the DateValue() function returns only the date part of a date variable.

 

[raskew]

Hi -

The Date() function returns the date only, e.g.:

? now()
9/11/2008 8:14:47 AM

? date()
9/11/2008

Refer to: http://support.microsoft.com/kb/q130514/ for an explanation of how Access stores dates and times.

HTH - Bob

 

[Kenln]

This is soooo simple... if you know it.

It is the obvious that I have the most problems with.

Thank you