topic Dates in Script in QlikView https://community.qlik.com/t5/QlikView/Dates-in-Script/m-p/162061#M35701 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I think you syntax is not complete:</P><P>IF('[ProductLaunchDate]=&lt;[Shipment Date]&gt;[ProductLaunchDate]+365','Yes','No') as NewLaunchProduct,</P><P>Try: if([ProductLaunchDate]=&lt;[Shipment Date] and [ProductLaunchDate]&gt;([ProductLaunchDate]+365),'Yes','No') as NewLaunchProduct.</P></BODY></HTML> Mon, 23 Nov 2009 19:17:52 GMT lmonincx 2009-11-23T19:17:52Z Dates in Script https://community.qlik.com/t5/QlikView/Dates-in-Script/m-p/162060#M35700 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Similar to my previous post on using ste analysis for calculating sales between dates. I would now like to bring a field into my script to say whether or not that line should be included.</P><P></P><P>Have tried</P><P></P><P>IF('[ProductLaunchDate]=&lt;[Shipment Date]&gt;[ProductLaunchDate]+365','Yes','No') as NewLaunchProduct,</P><P></P><P>and also tried using a variable but no luck.</P><P></P><P>Any help much appreciated</P><P></P><P>Thanks</P><P></P><P>Matt</P></BODY></HTML> Mon, 23 Nov 2009 18:59:20 GMT https://community.qlik.com/t5/QlikView/Dates-in-Script/m-p/162060#M35700 2009-11-23T18:59:20Z Dates in Script https://community.qlik.com/t5/QlikView/Dates-in-Script/m-p/162061#M35701 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I think you syntax is not complete:</P><P>IF('[ProductLaunchDate]=&lt;[Shipment Date]&gt;[ProductLaunchDate]+365','Yes','No') as NewLaunchProduct,</P><P>Try: if([ProductLaunchDate]=&lt;[Shipment Date] and [ProductLaunchDate]&gt;([ProductLaunchDate]+365),'Yes','No') as NewLaunchProduct.</P></BODY></HTML> Mon, 23 Nov 2009 19:17:52 GMT https://community.qlik.com/t5/QlikView/Dates-in-Script/m-p/162061#M35701 lmonincx 2009-11-23T19:17:52Z