topic How to Get as on Date Report! in QlikView https://community.qlik.com/t5/QlikView/How-to-Get-as-on-Date-Report/m-p/147307#M25746 <HTML><HEAD></HEAD><BODY><P>Ravi,<BR />No matter what value you assign to the AsOnDate variable by using the input field, it will be overritten by the LET statement in the script. Just remove it from the script.</P></BODY></HTML> Sat, 20 Jun 2009 20:15:31 GMT Anonymous 2009-06-20T20:15:31Z How to Get as on Date Report! https://community.qlik.com/t5/QlikView/How-to-Get-as-on-Date-Report/m-p/147306#M25745 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am Ravi, just started to work with qlik view, i am now using qlikview 9 personal Edition. I am using in the scirpt like this</P><P>Let AsOnDate = Num(today(0));</P><P></P><P>in my load statement i am filtering the query as like this</P><P>Select .....</P><P>From ...</P><P>Where AsOnDate between ....StartDate and ....EndDate;</P><P></P><P>this query is basically to find whether an employee is working with an organization as on the date provided by the user at the run time.</P><P></P><P>At the first time when i use, its fetching me all the date as on today, but while am changing the date in the input field the records were not refreshed!</P><P>What i need to do get the record to be filtered as per the input i have selected during the runtime.</P><P></P><P>Please help!</P><P>Thanks</P><P>Ravi!</P></BODY></HTML> Sat, 20 Jun 2009 11:53:16 GMT https://community.qlik.com/t5/QlikView/How-to-Get-as-on-Date-Report/m-p/147306#M25745 2009-06-20T11:53:16Z How to Get as on Date Report! https://community.qlik.com/t5/QlikView/How-to-Get-as-on-Date-Report/m-p/147307#M25746 <HTML><HEAD></HEAD><BODY><P>Ravi,<BR />No matter what value you assign to the AsOnDate variable by using the input field, it will be overritten by the LET statement in the script. Just remove it from the script.</P></BODY></HTML> Sat, 20 Jun 2009 20:15:31 GMT https://community.qlik.com/t5/QlikView/How-to-Get-as-on-Date-Report/m-p/147307#M25746 Anonymous 2009-06-20T20:15:31Z