topic DATE TO NUMBER OF DAYS in QlikView

DATE TO NUMBER OF DAYS

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear All

I want to get a number of days using given data

MARKETING_DATE - 31-05-2019

sagara

lazurens — Fri, 14 Jun 2019 06:58:06 GMT

It's not clear number of days since when exactly ?

If you mean number of days from the start of the year you can use the function DayNumberOf Year('05/31/2019')

If you mean the number of days between a date in the past and today

use this expression :

Regards,

Mohamed

sagaraperera — Fri, 14 Jun 2019 07:55:53 GMT

thanks boss it is work

can you help

get a last month max date using following

MARKETING_DATE

sagara

lazurens — Fri, 14 Jun 2019 08:28:51 GMT

MonthEnd(Max(Date(MARKETING_DATE)))

Mohamed