Joe Hecht
jmhecht at earthlink.net
Sat Jan 7 08:51:25 CST 2006
No. 65 is current correct & desired answer for this employee. Joe Hecht jmhecht at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Int(Format(Now(),"mmdd") will return the number 107 at the moment (7 Jan), or106 (6 Jan) for you. It would have returned the number 1231 at the end of last month (31 Dec). Are you sure that's what you want? -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com