Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ambiguous date/date-time constant
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
FoxPro Dos
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01130765
Message ID:
01130778
Views:
19
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform