https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1770497#M454584 <P>Try something like this.&nbsp;</P><P>Set vWeek=Week(date#('$(vInputDate)', 'DD/MM/YYYY'))&nbsp;</P> Fri, 25 Dec 2020 12:58:22 GMT Vegar 2020-12-25T12:58:22Z https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1770484#M454582 <P>I am sure I am missing something very straightforward, so some assistance would be appreciated.&nbsp; In my load script I load a master calendar, Which has a range of dates corresponding to the range of dates in the transaction file, plus the number of the week in the year. The date links to a date field in the transaction file I am loading.&nbsp; I want the user to enter a date (any date in the range of the master calendar) which I store in a variable I called 'vInputDate'. Based on the date the user enters I want to assign a variable the corresponding value of the week variable.&nbsp;</P><P>So if the user enters 12/12/2020, I want the week variable to reflect 50, and if the user enters 16/12/2020 I want the week variable to reflect 51. This needs to be done dynamically as the user can select whichever date he wants to report on.</P> Fri, 25 Dec 2020 10:00:11 GMT https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1770484#M454582 DexterAlex 2020-12-25T10:00:11Z https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1770497#M454584 <P>Try something like this.&nbsp;</P><P>Set vWeek=Week(date#('$(vInputDate)', 'DD/MM/YYYY'))&nbsp;</P> Fri, 25 Dec 2020 12:58:22 GMT https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1770497#M454584 Vegar 2020-12-25T12:58:22Z