Discussion board where members can get started with QlikView.
I want to get a number of days using given data
MARKETING_DATE - 31-05-2019
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 :
View solution in original post
thanks boss it is work
can you help
get a last month max date using following