Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem with expression script

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 )

4 Replies
tresesco
MVP
MVP

if(#num(ENTRY_DATE)<....

num# and NOT#num

simondachstr
Luminary Alumni
Luminary Alumni

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 )

Not applicable
Author

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.

Not applicable
Author

yes is num# and i miss a ) but not in the script.

The weekday is correct