T tintin16 Registered User. Local time Yesterday, 23:43 Joined Jul 14, 2004 Messages 12 Aug 27, 2004 #1 I have to select only those records which do not have a 'closing date' and then then find the date difference between the ' Open date' and 'current date' PLEASE HELP!!!
I have to select only those records which do not have a 'closing date' and then then find the date difference between the ' Open date' and 'current date' PLEASE HELP!!!
Mile-O Back once again... Local time Today, 04:43 Joined Dec 10, 2002 Messages 11,316 Aug 27, 2004 #2 Use Is Null as the criteria for the empty field. Use the DateDiff() function for calculating the difference between the dates.
Use Is Null as the criteria for the empty field. Use the DateDiff() function for calculating the difference between the dates.
