Date Only

[Elamranii]

Hi,
I am trying to get the date. I put this: Date() and I get 05/13/2005 9:46:15 AM. All I want to see is 5/13/2005. How do I do that?
Thanks in advance

 

[jsteph]

You could use format(date,"mm/dd/yyyy"),fix(date),fix(now), etc. I'm not sure where you 'put this', but if it's in a table you can set the format property for the field, same with a form.
--Jim

 

[Elamranii]

Great, it worked. Thank you.

Ismail