Help with a Where Clause date

[thehandsomecode]

Hello all, I need some help to figure this one out.

I am trying to type a where clause to gather the following

Here are the fields

 

assigneddate : datetoclose

 

I need to pull all records where the "assigneddate" is less than todays date and  "datetoclose" is sometime in the future.

however if the "datetoclose" field is empty i do not want it to evaluate the "datetoclsoe" is somewhere inthe future string. In that case I only want it to parse the "assigneddate" is less than today's date.

 

Please help.

 

 

[Maq]

Try something like this:

 

SELECT * from [table] WHERE (datetoclose = '') OR (assigneddate  [today])

 

If your datetoclose is default to null then change the logic to 'datetoclose IS NULL'.

[thehandsomecode]

Thank you.. you steared me in the right direction and i was able to sort it out.

[Maq]

Thank you.. you steared me in the right direction and i was able to sort it out.

 

Np, glad you sorted it out.