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"
