Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thank You guys I got it trying this Thanks.
Count(
{
$<State={'Committed','QC','Promote'},TargetDate2={"<$(=Today())"}>
+
$<State={'Committed','QC','Promote'}, TargetDate2 ={'NULL',"< Today()"}>
}
WorkID)
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
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
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()
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.
tried with variable also not working
tried not working thank you however
Thank You guys I got it trying this Thanks.
Count(
{
$<State={'Committed','QC','Promote'},TargetDate2={"<$(=Today())"}>
+
$<State={'Committed','QC','Promote'}, TargetDate2 ={'NULL',"< Today()"}>
}
WorkID)
Check the format of the date field. Date format you are using might be string