Re: Problem comparing date/time field to $DATE$ in a filter

2012-12-03 Thread Jason Miller
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

Re: Problem comparing date/time field to $DATE$ in a filter

2012-12-03 Thread Jason Miller
, 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

Re: Problem comparing date/time field to $DATE$ in a filter

2012-11-28 Thread Longwing, LJ CTR MDA/IC
@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

Re: Problem comparing date/time field to $DATE$ in a filter

2012-11-28 Thread Rick Westbrock
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

Re: Problem comparing date/time field to $DATE$ in a filter

2012-11-28 Thread Longwing, LJ CTR MDA/IC
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

Re: Problem comparing date/time field to $DATE$ in a filter

2012-11-28 Thread Rod Harris
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

Re: Problem comparing date/time field to $DATE$ in a filter

2012-11-28 Thread Rick Westbrock
, 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

Problem comparing date/time field to $DATE$ in a filter

2012-11-27 Thread Rick Westbrock
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

Re: Problem comparing date/time field to $DATE$ in a filter

2012-11-27 Thread Rod Harris
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.