Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
can you help me with this expression?
something is wrong?
= if(#num(ENTRY_DATE)<num#(if(weekday(today())='Mo', date(today()-10), if(weekday(today())='Sa', date(today()-9), date(today()-8)),
nullcount(MISSION_OPEN), 0 )
if(#num(ENTRY_DATE)<....
num# and NOT#num
Furthermore one bracket ) is missing
= if(num#(ENTRY_DATE)<num#(if(weekday(today())='Mo', date(today()-10), if(weekday(today())='Sa', date(today()-9), date(today()-8))),
nullcount(MISSION_OPEN), 0 )
It looks like its your weekdays that are causing the issue. I think it should be 'Mon' and 'Sat'.
If you try that, it may help.
yes is num# and i miss a ) but not in the script.
The weekday is correct