Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Interval(now() - due_date,'DD') as DaysDiff
look in the HELP section about interval function...very powerful in Qlikivew
Cheers,
Patric
try networkdays(today(), due_date)
if( interval(due_date - today(), 'd') >=1 and interval(due_date - today(), 'd') <= 30, 'True', 'False')
Interval(now() - due_date,'DD') as DaysDiff
look in the HELP section about interval function...very powerful in Qlikivew
Cheers,
Patric
Thanks for all your help as always guys.. I used Patric's solution in the end