RE: [AccessDevelopers] Date format problem

[Hoffman, Tobi K \(DYS\)]

Title: Message

Use Date() instead of Now(); Date() does not include the time.  If you're working on too early an Access version, you can use Format(Now(),"mm/dd/yyyy") or (I think) DateValue(Now()).   Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 1:15 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Date format problem   I have a date field where the default value is Now(), however I only want the dd/mm/yyyy format. I am getting the time as well. I changed the format to shortdate but that only changes the appearance when you click on the field it still has the date and time.   Can anyone help me with this.   thanks.   marc Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.