Discussion Board for collaboration regarding Qlik DataMarket.
I have today's date in the format say 'YYYY-MM-DD'. I want to get the date seven days before this date.
eg. Suppose today's date is '2017-08-28'. So my requirement is to get the date value as '2017-08-21'.
What I am doing to achieve this is:
Let StartDate = Date(today(), 'YYYY-MM-DD');
But this doesn't suffice my problem. Can anyone please help me out with any suggestion.
Thanks and Regards,
Go to Solution.
Let StartDate = Date(today()-7, 'YYYY-MM-DD');
Thanks Antonio. It worked !!!!!
I need to get the data which i need to filter in qlikview script to get data for seventy days from today's date as the date is in epoch format