Hi Boris
Thanks very much. I used the first option and it worked (well - I didn't get an error).
Unfortunately with one run, where I used a set of files in one format, where the input "date" string was blank, I got a default date of 01-01-1970 (understandable) and the rest seemed to be correctly converted.
However, in the "trouble" set of files (those with the > 253 strings) ALL the dates got converted to 01-01-1970, blank or not. ANy ideas?
>
>funct getdate(secs)
> xdays = int(secs/secsday)
> xdate = {^1970-01-01} + xdays
>return xdate
>
>
>I am not sure for DOS but I love this VFP option:
>
>funct getdate(secs)
> xdays = int(secs/secsday)
> xdate = DATE(1970,1,1) + xdays
>return xdate
>
>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.