Current Date

[tintin16]

I need a query to generate the date difference between a given start date and the current date.
Please help!!!

 

[tintin16]

Wrong Question

I have the date difference. I need to select only those record which are blank/empty.

I have to select those records which do not have a 'closing date' and then then find the date difference between the ' Open date' and 'current date'

 

[ColinEssex]

In your query use the "IsNull" in the criteria to get the blank closing dates.

DateDiff() will calculate the difference between dates (and times)

Col

 

[ColinEssex]

There's no need to post the same question twice