Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Rod Harris
*Sent:* Wednesday, November 28, 2012 8:48 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Problem comparing date/time field to $DATE$ in a filter
** **
** Yes LJ, a date field doesn't worry
, November 28, 2012 9:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Problem comparing date/time field to $DATE$ in a filter
Thanks for the explanation Rod, I had it in my head that both values were
using the server's UTC value and didn't realize that it was translating the
user's value from their time
@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Tuesday, November 27, 2012 5:05 PM
To: arslist@ARSLIST.ORG
Subject: Problem comparing date/time field to $DATE$ in a filter
Hello all-
I have got a real brain burner on my hands with a filter in a custom
application that we are hosting. This filter has
discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Tuesday, November 27, 2012 5:05 PM
To: arslist@ARSLIST.ORG
Subject: Problem comparing date/time field to $DATE$ in a filter
Hello all-
I have got a real brain burner on my hands with a filter in a custom
to display date only.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Wednesday, November 28, 2012 9:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Problem comparing date/time field to $DATE$ in a filter
Of Rick Westbrock
Sent: Wednesday, November 28, 2012 9:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Problem comparing date/time field to $DATE$ in a filter
Thanks for the explanation Rod, I had it in my head that both values were
using the server's UTC value and didn't realize
, 2012 8:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Problem comparing date/time field to $DATE$ in a filter
** Yes LJ, a date field doesn't worry about timezones so would solve Rick's
problem for sure.
The main issue I had with it is that the control is not as user friendly as
a date only
Hello all-
I have got a real brain burner on my hands with a filter in a custom
application that we are hosting. This filter has as part of its
qualification the following clause: ('TR.DateField' != $DATE$) where
DateField is a date/time field set to display date-only. This filter had
been
Hi Rick,
All date times whether or not they are set to display as a date only or not
are stored and evaluated as the number of seconds since midnight 1/1/1970
UTC.
Active links use the datetime of the client when evaluating the $DATE$
keyword and set it to midnight local time of the current day.
9 matches
Mail list logo