topic Days from current day in QlikView

Days from current day

Mon, 27 Feb 2017 12:31:51 GMT

I have a date called INVOICE_DATE.

I want to in script to do the following :

a) If INVOICE_DATE is not within the 30 days ( from today's date ) then INVOICE_PASS

B) if INVOICE_DATE is within 30 days (from today) then INVOICE_OK

c) if INVOICE_DATE is in the past ( ie yesterday and beyond ) then INVOICE_EXPIRED

Re: Days from current day

rahulpawarb — Mon, 27 Feb 2017 12:42:11 GMT

Hello Shibli,

Considering above requirements, you can compose below fields:

If(Today()-INVOICE_DATE>30, 'INVOICE_PASS', 'INVOICE_OK') AS Status,
If(Today()-INVOICE_DATE>0, 'INVOICE_EXPIRED', 'INVOICE_NOT_EXPIRED') AS IsInvoice_Expired

Regards!

Rahul