Set Analysis with null and or exceeded dates

[#1]

Hey Guys need a little help , 

Count({$<State={'Committed','QC','Promote'},TargetDate2={"< Today()"}>

+

$<State={'Committed','QC','Promote'}, TargetDate2 ={'NULL'}>

}WorkID)

I need states that are Commited Qc and promote  with either Target date is = 'NULL'  or with a target date <  Today

I am only getting nulls  in  but not exceed dates. 

Thank You.

[miguelbraga]

Your set analysis expression is wrong as far I know it should be something like this:

=Count({$<State={'Committed','QC','Promote'},TargetDate2={$(=Today())}>WorkID) +

Count({$<State={'Committed','QC','Promote'},TargetDate2={$(=null())}>WorkID)

Hope it helps

[#3]

Not working  I need both Dates Less than Target date and 'NULL'  In TargetDate2 I have a filter that outputs nulls as NULL.  (for selection purposes .  Thank You however

[miguelbraga]

UPDATED:

Try this change:

=Count({$<State={'Committed','QC','Promote'},TargetDate2={"<$(=vToday)"}>WorkID) +

Count({$<State={'Committed','QC','Promote'},TargetDate2={'NULL'}>WorkID)

And add a variable with the name:

vToday      With the expression          =Today()

[tamilarasu]

You can also try lik this...

=Count({$<State={'Committed','QC','Promote'},TargetDate2={"<$(=date(today(),'DD.MM.YYYY'))"}>WorkID) +

Count({$<State={'Committed','QC','Promote'},TargetDate2={'NULL'}>WorkID)

I assume that the date format for the field Target2 as 'DD.MM.YYYY'.. If not change it according to your data.

[#6]

tried with variable also not working

[#7]

tried not working thank you however

[#8 · Accepted solution]

Thank You guys I got it trying this Thanks.

Count(

{

$<State={'Committed','QC','Promote'},TargetDate2={"<$(=Today())"}>

+

$<State={'Committed','QC','Promote'}, TargetDate2 ={'NULL',"< Today()"}>

}

WorkID)

[varunreddy]

Check the format of the date field. Date format you are using might be string