8 Replies Latest reply: Feb 28, 2017 8:08 AM by Arghya Ray RSS

    How to set start and End Date?

    Arghya Ray

      My objective is to assign a variable with start date which is equal to the date on which the report is generated.(basically it should take the system date as the start date on the day of generation)

      Likewise another variable is to be assigned which is the end date that is two weeks before the start date.

      I did try the following command:

      Let StartDate = Input('Enter Start Date (MM/DD/YYYY)' , 'Input required'); But here I had to feed the date manually which I dont wan't. The Qlikview script should take the system date automatically.

      The End Date should be set accordingly. (eg something like Let vEndDate = VStartDate - 14 days)

      Can anybody please help me out? Thanks in advance!!!!