cancel
Showing results for 
Search instead for 
Did you mean: 

Date Range and Null Values

Former Member
0 Kudos

Post Author: mrae

CA Forum: Formula

I want to pull up data that have been completed for the month, but also want to include null values. I did the following but didn't work.

(isnull({wrhwr.date_completed}) or {wrhwr.date_completed} => 4/1/2008 12:00:00AM or =<4/30/2008 11:59:59PM

Help, please?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: mrae

CA Forum: Formula

Thank you sooo much .... it works!! Appreciate it really.

Former Member
0 Kudos

Post Author: SKodidine

CA Forum: Formula

Try:

isnull({wrhwr.date_completed}) or {wrhwr.date_completed} IN datetime(2008,04,01,00,00,00) to datetime(2008,04,30,23,59,59)