How to parse a week number as date ?

fbeck_br August 28, 2014
I have issues with 2 fields i need to compare. 1. End date (type: date) eg: 2014/08/30 2. Shipment Week (type: select list) eg: W01, W02, etc Now i need to filter all issues where Interval between end date and shipment week is less than 2 weeks. Eg: issueFunction datecompare("", week < date (2w)) How can i convert the string W30 to a date , so i can compare? Or should be possible to use another field type for week, instead of select list? Tks

1 answer

0 votes
Steven F Behnke
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 28, 2014

Huh. So to be clear, what does this Shipment Week field represent? A week out of the year?

Suggest an answer

Log in or Sign up to answer