Yes, that should work. Although the $DATE$ keyword can be used for both Date and Date/Time fields, using an arithmetic operation against the keyword seems to force it to translate into a date/time value (# of seconds instead of # of days) at the database level. You can observe this by running a SQL log on the server.
Search Qual in Advanced Search bar in WUT: 'zDateField' >= $DATE$ Corresponding query in SQL log ($DATE$ keyword converted to current Date integer value - # of days since January 1, 4713 B.C.): SELECT TOP 2147483649 T535.C1,T535.C1 FROM T535 WHERE (T535.C536870947 >= 2454767) ORDER BY 1 ASC Search Qual in Advanced Search bar in WUT: 'zDateField' >= $DATE$ - 7 Corresponding query in SQL log ($DATE$ keyword converted to current Date/Time integer value - # of seconds since January 1, 1970 12:00:00 AM GMT): SELECT TOP 2147483649 T535.C1,T535.C1 FROM T535 WHERE (T535.C536870947 >= (1225083600 - 7)) ORDER BY 1 ASC The environment I tested this on is ARS 7.0.1 with a SQL Server 2005 database. --Thomas ----- Original Message ----- From: LJ Longwing Newsgroups: gmane.comp.crm.arsystem.general To: [email protected] Sent: Monday, October 27, 2008 10:28 AM Subject: Re: Adding days to a Date field in a qualification doesn't work Oh...I know why it's not working....because $DATE$ can be used for both Date and Date/Time fields....and remedy probably does some dynamic stuff to the value when you are doing a compare with a date field...so what you may need to do is setfield ztmp_datefield = $DATE$ setfield ztmp_datefield = +182 then in another filter my_date_field > ztmp_datefield I bet that would work -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug Sent: Monday, October 27, 2008 9:18 AM To: [email protected] Subject: Re: Adding days to a Date field in a qualification doesn't work Try 'my_date_field' > ($DATE$ + 15724800) Humor me Doug -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Monday, October 27, 2008 11:08 AM To: [email protected] Subject: Re: Adding days to a Date field in a qualification doesn't work > 'my_date_field' > ($DATE$ + 182) > so that it will add 182 to the date before doing the compare? Yes, that's exactly what I did. Mark ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
