topic Today function in script in QlikView https://community.qlik.com/t5/QlikView/Today-function-in-script/m-p/236981#M88104 <HTML><HEAD></HEAD><BODY><P>Never mind I figured it out.</P><P>I used <STRONG>date</STRONG>(today(1)) and it worked!!</P></BODY></HTML> Thu, 03 Mar 2011 00:17:26 GMT 2011-03-03T00:17:26Z Today function in script https://community.qlik.com/t5/QlikView/Today-function-in-script/m-p/236980#M88103 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am trying to formulate an if statement in the script so that a date of 9/9/1999 will be changed to the current date. Below is my statement:</P><P></P><P>if ([QMIH.MalfunctStart_AUSVN] = '9/9/1999' , today(1), QMIH.MalfunctStart_AUSVN) as adjustedDefectDate</P><P>however any occurence of 9/9/1999 now returns 40604. it's 3/2/2011 so I'm a little confused.</P><P>I've tried today(), today(1), and now()</P><P>Really weird. Can someone help me?</P><BR /><BR /></BODY></HTML> Thu, 03 Mar 2011 00:09:43 GMT https://community.qlik.com/t5/QlikView/Today-function-in-script/m-p/236980#M88103 2011-03-03T00:09:43Z Today function in script https://community.qlik.com/t5/QlikView/Today-function-in-script/m-p/236981#M88104 <HTML><HEAD></HEAD><BODY><P>Never mind I figured it out.</P><P>I used <STRONG>date</STRONG>(today(1)) and it worked!!</P></BODY></HTML> Thu, 03 Mar 2011 00:17:26 GMT https://community.qlik.com/t5/QlikView/Today-function-in-script/m-p/236981#M88104 2011-03-03T00:17:26Z