Once again - Thanks John!!!!! -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Tuesday, January 24, 2006 4:57 PM To: [email protected] Subject: RE: [ms_access] Formatting for long date with time
Mike- Use Now instead of Date: IIf(Time()>=#7:00:00 PM#,Now()+1,Now()) John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 24, 2006 3:12 PM To: [email protected] 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 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/
