Is there an easy way to know if a column is Date/Time?
Mar 15, 2016 12:31 PM(4644 views)
So I had a script that ran something like this:
for(i=1, i<=ncols(dt), i++,
name =Column(dt, i)<<Get Name;
However, I've found that not all columns have "Date" or "Time" in the name. Sometimes due to misspelling (like Tme, Tim, ect.) Sometimes b/c it's just not included b/c the columns are arbitrarily named-"Column 1", "Value 2", ect. Anyways, I've been experimenting with '<< Get Format', but this doesn't seem to be consistent either.
Most of these files are coming from .csv generated by other programs. Maybe there's a preference somewhere that would default Date formats to be a specific one of interest I could query?