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:[email protected]] On Behalf Of Downing, Ryan
Sent: Tuesday, August 13, 2013 7:54 AM
To: [email protected]
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:[email protected]] On Behalf Of Joe D'Souza
Sent: Monday, August 12, 2013 10:13 PM
To: [email protected]
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"

Reply via email to