Yeah, It is at the database level a Date/Time field, the DISPLAY property is TIME
:) Doug -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, October 27, 2008 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: Adding days to a Date field in a qualification doesn't work Yeah, I think that doug is on to something here. The $DATE$ keyword is referring to seconds, I believe, and thus you need to add six months worth of seconds. Note, that $DATE$ calculates to midnight that day, so if you need to calculate six months from now, then you will likely need to use $TIMESTAMP$. Using $DATE$ will give you 6 months from the beginning of the current day. Also, as a good note, I would suggest adding the parenthesis, although they should not be required. Thanks, Gary -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug Sent: Monday, October 27, 2008 10:18 AM To: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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" 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"