Help with expression

[Anonymous]

Hi guys,

I have the following in SQL

datediff(dd,due_date,getdate()) between '1' and '30' - This is basically doing between 1 and 30 days from today..

Can I recreate this as an expression?

Thanks

[villegasi03]

try networkdays(today(), due_date)

[Gysbert_Wassenaar]

if( interval(due_date - today(), 'd') >=1 and interval(due_date - today(), 'd') <= 30, 'True', 'False')

[pamaxeed · Accepted solution]

Interval(now() - due_date,'DD') as DaysDiff

look in the HELP section about interval function...very powerful in Qlikivew

Cheers,

Patric

[Anonymous]

Thanks for all your help as always guys.. I used Patric's solution in the end