Hi Thomas, There are a fair number of verbs dealing with date ordering and conversions in the standard library script at system/main/stdlib.ijs The overview is found here: https://code.jsoftware.com/wiki/Standard_Library/dates
Hope this helps. Cheers, bob > On Mar 31, 2021, at 20:45, Thomas Bulka <[email protected]> wrote: > > Hello everyone, > > I recently decided to use J more "professionally" and do some real world > data analysis in J. For most of the time this works quite well - but in > some (sadly simple) cases I need the help of the forum. > > I've got some data in a lot of CSV files and I'm able to process most of > the data (numerical data, strings), the way I want. What I'm not sure > about, is, however, the question how to represent dates in J. > > Say, I have a column in my CSV which contains strings representing > German style dates (dd.mm.yyyy) - which would be a good J representation > of a date? As far as I know, there is now native J data type for > dates. I need to be able to do some simple comparisons on the date > (which one is earlier/later?, did events happen on the same date?) and > that is basically it. > > I therefore would like to know, what representation you would suggest? > Should I go with a plain integer representation (the digits representing > yyyymmmdd) or are there other and probably more idiomatic ways? > > Kind regards, > > Thomas > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
