Null Value

tintin16

Registered User.
Local time
Today, 06:18
Joined
Jul 14, 2004
Messages
12
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!!!
 
Use Is Null as the criteria for the empty field.

Use the DateDiff() function for calculating the difference between the dates.
 

Users who are viewing this thread

Back
Top Bottom