Dates in Script

[#1]

Hi

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.

Have tried

IF('[ProductLaunchDate]=<[Shipment Date]>[ProductLaunchDate]+365','Yes','No') as NewLaunchProduct,

and also tried using a variable but no luck.

Any help much appreciated

Thanks

Matt

[lmonincx]

hi,

I think you syntax is not complete:

IF('[ProductLaunchDate]=<[Shipment Date]>[ProductLaunchDate]+365','Yes','No') as NewLaunchProduct,

Try: if([ProductLaunchDate]=<[Shipment Date] and [ProductLaunchDate]>([ProductLaunchDate]+365),'Yes','No') as NewLaunchProduct.