SQL statement query help with Date

[caddyjoe77]

Hi, i searched around but didnt find exactly what I was looking for. I leave it to you SQL experts!

Seriously though, i have a field in one of my DB tables that is CompletionDate.


If there is a date in there, i dont care from the query's perspective, i only care if there is a NULL value. I am using this DB to track requirements.

I tried the following but it threw an error

SELECT IttNumber, IttTitle, DateRequired, CompletionDate
FROM tbl3215
WHERE (CompletionDate = 'NULL')

i have also tried WHERE (CompletionDate < $TODAY)

but that didnt work either, Basically, what i want to do is run a query against all requirements that are not completed.

Can anyone help?? Thanks in advance!

J

[caddyjoe77]

Hi, i searched around but didnt find exactly what I was looking for. I leave it to you SQL experts!

Seriously though, i have a field in one of my DB tables that is CompletionDate.


If there is a date in there, i dont care from the query's perspective, i only care if there is a NULL value. I am using this DB to track requirements.

I tried the following but it threw an error

SELECT IttNumber, IttTitle, DateRequired, CompletionDate
FROM tbl3215
WHERE (CompletionDate = 'NULL')

i have also tried WHERE (CompletionDate < $TODAY)

but that didnt work either, Basically, what i want to do is run a query against all requirements that are not completed.

Can anyone help?? Thanks in advance!

J

I got it, hope this helps someone in the future

SELECT IttNumber, IttTitle, DateRequired, CompletionDate
FROM tbl3215
WHERE ([CompletionDate] is NULL)

[Taftheman]

Try just

Where Completion Date is null

[patjones]

Hi!

I am currently working with null date values in my project also, and this is the SQL syntax that seems to work. Give it a shot...

SELECT IttNumber, IttTitle, DateRequired, CompletionDate

FROM tbl3215

WHERE ((tbl3215.CompletionDate) Is Null)

Let us know what happens!

Best,

Pat