Mike & Doris Manning
mikedorism at adelphia.net
Mon Dec 1 11:23:56 CST 2003
Now() = Current date/time Now() - 7 = Current time on the date that was seven days ago... Now() - 3 = Current time on the date that was three days ago... Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Oleg_123 at xuppa.com Sent: Monday, December 01, 2003 11:11 AM To: accessd at databaseadvisors.com Subject: [AccessD] Format ? Hey, I don't understand what is trying to be achieved here ? Iget a null when I just do (Format(Now()-7,"mm-dd")) The format in Auddate column is "mm-dd" WHERE (((audit.AUDDATE)>=Format(Now()-7,"mm-dd") And (audit.AUDDATE)<=Format(Now()-3,"mm-dd")) AND ((Val(Left([employee status],1)))<>5 Or (Val(Left([employee status],1)))=9) AND ((Left([ACTCODE],1))="1")) ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com