Again, if you research Julian dates you will see that there are several different commonly accepted algorithms - all yeilding different results.
I personally would not trust that the "Ruby" alogorithm matches the ARS algorithm. So, I would tend to use the ARS algorithm since they have a nice f() for converting it anyhow. I don't mind supplying a small binary that converts these types of dates and you can check random (arbirary) dates against Ruby and the binary to see that the returned values match (especially for the negative numbers). Contact me off-list if you want it. It will require API dlls/so and all dependencies of that as these incidental functions are not separated in the AR API libs. Cheers Ben >----- ------- Original Message ------- ----- >From: :[email protected] >To: [email protected] >Sent: Fri, 29 Jul 2011 12:26:14 > >OK - a bit of digging on dates and 4713 -- it >appears to be a Julian date. > > >Solved: > >Ruby > > >require 'Date' > >jruby-1.6.3 :024 > Date.jd_to_civil(2455767) > => [2011, 7, 24] > > > > >-John > > > >On Jul 29, 2011, at 12:01 PM, Grooms, Frederick W >wrote: > >From the Docs > >Date and time fields >There are three types of date and time fields: > >Date/time fields >Store calendar dates and time together. You can set >the display type to Date Only or Time Only so that >the user sees only the date or time. >AR System stores date/time values as the integer >number of seconds since 00:00:00 GMT, January 1, >1970. Dates from January 1, 1970 through January >18, 2038 GMT are valid in date/time fields. > >If the user enters only a time, then the current >date is assumed. If the user enters only a date, >then the time defaults to 12:00:00 AM. > >Date fields >Store date information only, as the number of days >from the beginning of its range. Use a Date field >when you want to compare two dates or perform >calculations based on the date, such as calculating >the number of days between two dates. Users can >enter dates from January 1, 4713 B.C. to January 1, >9999 A.D. in the Date field. > >Time fields >Store time information only, as the number of >seconds from 12:00:00 AM. Use a time field to >compare two times or perform calculations based on >time, such as the number of seconds elapsed. >The value in a time field is independent of the >time zone. While a date/time field adjusts the >displayed value to reflect the user's time zone, >the time value in a time field remains unchanged >when displayed on the client. > >Fred > >-----Original Message----- >From: Action Request System discussion >list(ARSList) [mailto:[email protected]] On >Behalf Of Kirill Eitvid >Sent: Friday, July 29, 2011 10:51 AM >To: [email protected] >Subject: Re: ARX File Reader Utility > >** John, > >as far I remember it's the number of days passed >since 01.01.1970 for DATE and number of seconds >since 01.01.1970 00:00:00 for DATETIME. Try it. > > >-----Original Message----- >On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg >wrote: >** >I am getting closer :) > > >If the .arx value of a DATE field is 2455767 .... > >How does that get converted to human readable? > >Meaning -- does anybody know the conversion >strategy? > > >1) Upload (which gets parsed for field names, types >etc...) >https://skitch.com/johnsundberg/fc1ye/kinetic-data- >inc > >2) Select fields you want to see >https://skitch.com/johnsundberg/fct9m/kinetic-data- >inc > >3) View >https://skitch.com/johnsundberg/fct95/kinetic-data- >inc > > >4) Party!!! > > >-John > >-- >John Sundberg > >Kinetic Data, Inc. >"Building a Better Service Experience" >Recipient of: >WWRUG10 Best Customer Service/Support Award >WWRUG09 Innovator of the Year Award >[email protected] >651.556.0930 I www.kineticdata.com > > >-----Original Message----- >On Jul 24, 2011, at 4:03 PM, Mike Buck wrote: > >** >Thank you > >I'll take a look. > >Kind regards > >-----Original Message----- >On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky >wrote: >Hi, > >We have a tool that can do something like that, and >more. > >It is called RRR|ArxToHTML, and can be downloaded >from: >https://www.rrr.se/cgi/tools/main#rrrArxToHTML > >You will get the best result if you have a def-file >with the >form-definition, as it will allow the tool to sort >field by the form >layout, use labels instead of database names, >selection field values etc. >You will get a result list with the normal >entry-list-fields and links to >individual records. > >The quick way to use it to convert an ARX-file to a >table is to run it >like this: >rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html > >This will create a single HTML-file with a table >including all fields of >the ARX-file. > > Best Regards - Misi, RRR AB, >http://www.rrr.se > >Products from RRR Scandinavia (Best R.O.I. Award at >WWRUG10): >* RRR|License - Not enough Remedy licenses? Save >money by optimizing. >* RRR|Log - Performance issues or elusive bugs? >Analyze your Remedy logs. > >-----Original Message----- >> It would be SO good to view ARX files, without >having to import to the >> target form, in order see all the data. >> >> Is anyone willing to share a utility, or build >one to share, which will >> parse an ARX file and present it in an easy to >digest form? >> >> The data could be presented with column headers >in notepad for example, or >> even better in Excel (similar to how a CSV file >is presented). >> >> This would be a really fantastic tool for code >reviews and carry out >> pre-deployment checks. >> >> I really do hope someone is able to help:) >> >> Thanks very much >> Mike > >___________________________________________________ >____________________________ >UNSUBSCRIBE or access ARSlist Archives at >www.arslist.org >attend wwrug11 www.wwrug.com ARSList: "Where the >Answers Are" > >-- >John Sundberg > >Kinetic Data, Inc. >"Building a Better Service Experience" >Recipient of: >WWRUG10 Best Customer Service/Support Award >WWRUG09 Innovator of the Year Award > >[email protected] >651.556.0930 I www.kineticdata.com > >___________________________________________________ >____________________________ >UNSUBSCRIBE or access ARSlist Archives at >www.arslist.org >attend wwrug11 www.wwrug.com ARSList: "Where the >Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
