Actually, it would be a "general" format date that I'm looking for.
-----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 24, 2006 4:12 PM To: ms_access@yahoogroups.com Subject: [ms_access] Formatting for long date with time Hi All, I have the following in an update query: IIf(Time()>=#7:00:00 PM#,Date()+1,Date()) What this does is advance the date to the next day if the current time is => 7pm (we run 12 hour shifts and the next work day actually starts tonight at 7pm). The problem with this is that it's only giving me a short date. I need it to format as a long date with the time. As always any help is greatly appreciated :) ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
