Hi Joe, I have done the same in the past.....but......just like a date/time field we have to use seconds for the manipulation........
I just tried the same for fun.....and it holds true.....seconds are required. Regards, Ryan. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Monday, August 12, 2013 10:13 PM To: arslist@ARSLIST.ORG Subject: Date field calculations using $DATE$ in the expression.. (SANITY CHECK) ** This is like a sanity check just to make sure I am not doing something wrong. If in a Date only field (Not Date / Time field with Display type as Date), if I were to manupulate a date value of 15 days from now, I would still need to find the number of seconds in 15 days and add it to the $DATE$ value, right? I asked this because that is what I had to do, and I thought Date only field was number of days from a certain calander date B.C to a certain calander date B.C.E. (details unimportant) so with that one would think it would be enough to just add 15 to $DATE$ to get 15 days ahead. However I get proper results only when I find the number of seconds in those 15 days and add to $DATE$, which I thought is kind of what I might have not expected. Joe _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"