Re: OT Re: DATE fields and queries

[Aaron Keller]

** Well, I’ll tell you I won’t be using them anymore.  They’re a pain in my ARS!   I used a Date type for a ‘Birth Date’ field, since many people here have a birthday prior to the beginning of Remedy Time (1/1/1970).    But now I’m kind of wishing I had just used a char field with a lot of workflow to format and parse it for the age calculations.   Besides the problem I mention below, there is the Web dialog popup for the field, which lists year first, then month and day, and includes a check box for BC.  Granted that’s fine for most of the world, but around here the users were confused to no end.  (After all, who has a B.C. birthday?)  And to change that popup, I had to hack a _javascript_ file (ar_date_popup.jsp)   -Aaron * Email: [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Tuesday, September 26, 2006 12:49 PM To: arslist@ARSLIST.ORG Subject: OT Re: DATE fields and queries   ** Just wondering how many people out there are using Date fields other then what is OOTB? I have found I usually run into some kind of issue when I use them (granted I haven't used them much since they were first added to ARS). About the only thing I use them for currently is to put a nice looking date in an email (users don't care much to see 09/22/06 17:58:15). Jason On 9/26/06, Aaron Keller <[EMAIL PROTECTED]> wrote: ** I'm using a Date field type (not a date/time field that displays date only – an actual date field) and thus the problem.       -A   From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: Tuesday, September 26, 2006 12:00 PM To: arslist@ARSLIST.ORG Subject: Re: DATE fields and queries   ** The Date field works the same as the Date/Time field from the database side.  They both record time in seconds.   The difference is from the User side.  Date does not give you time of day selection, but it will set to 00:00:00 for the day choosen.  So your query would have to be: ('Effective Date' >= $DATE$ - (60*60*24)) OR ('Effective Date' >= $DATE$ - 86400)   .ron   On 9/26/06, Aaron Keller < [EMAIL PROTECTED]> wrote: ** I've got a DATE field (not a Date/Time field) from which I want to query relative to the current day.   This works:  ('Effective Date' >= $DATE$)   But this does not: ('Effective Date' >= $DATE$ - 1)   But strangely enough, this DOES work: ('Effective Date' >= $DATE$ - 1156789196)   So it looks like the $DATE$ keyword evaluates in the date format (days) when used by itself with a date field, but evaluates in the date/time format (seconds) when used in arithmetic.  The problem is that each day will add another 864399 to what needs to be subtracted, which makes things much more complicated for an escalation!   Is there some way to work with date fields in queries that I'm missing?   -Aaron * Email: [EMAIL PROTECTED]   SunCom is the wireless company that's committed to doing things differently. Things we want you to know. This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by the attorney-client privilege. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___