Ahh yes. I knew that little voice was whispering some thing to me. It's been a long time since I setup the work flow in our time tracking control panel that retrieves records based on a Date field. It was the issue with $DATE$ that made me use a hidden Date field in my qualification statement.
Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ Longwing Sent: Monday, April 27, 2009 4:41 PM To: [email protected] Subject: Re: Qualification statement ** You may be having one of several problems...if 'Will Expire Date' is truly 'Date' not 'Date/Time'...then the values stored in there are 1 per day, not 86400 per day...so your qual would be $DATE$+15 if you are looking for 15 more days. Another issue you may be coming up against is that $DATE$ may be used for either Date or Date/Time fields....and when you force an arithmetic calculation on it then you force it to choose either Date or Date/Time before it can figure out what type of field it's being compared about...so it may not be making it a Date value instead of a Date/Time value. If you run SQL logging on the two qualifications you have compared you will likely find that there is something VERY different that the field is being compared to...the best way I have found in the past to do this is take $DATE$, store it in a tmp Date field, then in a separate action add 15 to it...then compare the tmp field to your real field. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Kelley Sent: Monday, April 27, 2009 2:33 PM To: [email protected] Subject: Qualification statement Hi Can someone tell me why this statement fails? 'Will Expire Date' > ($DATE$ + (((60 * 60) * 24) * 15)) Where this one does work. 'Will Expire Date' < $DATE$ The Will Expire Date is a Date field which is an expiration date. A message pops up saying ' the expiration date is expired... " when the record is accessed. What I wanted is to have another message come up if the Will Expire Date is 15 days more than today date. Then a message should say "not expired yet..." Anything within the 15 days should allow the other workflow. ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
