Re: Date field calculations using $DATE$ in the expression.. (SANITY CHECK)
Yup the funny thing about the design though is that if you actually subtract a higher date from a lower you get the exact number of days as the difference and not the difference in seconds between now and the midnight of that date. That kept me wondering why the two calculations were based off two different unit of measurements one in seconds and the other in days.. Just in case I wasn't clear in my statement above, today is 08/13/2013, so if you do a 08/14/2013 - $DATE$ on date fields, you get 1.. However if you want to set tomorrows date you would have to $DATE$ + 86400 on Date Only fields calculations.. Just a bit odd of a design and I have not really been able to figure out the rational behind it.. Cheers Joe PS: Try it for fun.. _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Downing, Ryan Sent: Tuesday, August 13, 2013 7:54 AM To: arslist@ARSLIST.ORG Subject: Re: Date field calculations using $DATE$ in the expression.. (SANITY CHECK) 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"
Re: Date field calculations using $DATE$ in the expression.. (SANITY CHECK)
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"
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"