Date fields are different than Date/Time fields. For Date fields you should add number of days instead of number of seconds.
A little nagging voice in the back of my head says that there is an issue with adding days in a qualification line. I think I had to add it to a hidden Date field and then compare the 2 fields. ------Original Message------ From: John Kelley To: Arslist ReplyTo: Arslist Subject: Qualification statement Sent: Apr 27, 2009 4:33 PM 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. Dave ------------------------- [email protected] (Wireless)
