Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Valid Dates
Message
From
30/12/1999 14:39:38
 
 
To
30/12/1999 14:33:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00309646
Message ID:
00310621
Views:
31
>>>I have a question regarding dates in Visual FaxPro 5.0. Is there a way of storing dates (as 'date' not 'char') that have 1 or 2 out of
>>>date/month/year missing; e.g. dates like 11/27/0000, 00/00/1901,
>>>12/00/1788?
>>>
>>>Thanks Austin
>>
>>No. FoxPro requires valid dates or else it is not a date.
>
>Are there any tricks to get around this problem for me.

The only thing I can think of is to use character strings for dates. But you said you didn't want to do that. Or maybe you could break it down into 3 numeric fields, year, month, day. (if you do this, be sure to change the names so that they are not the same as the VFP reserved words) Any way you do this is going to take some massaging on your part, because a "date" variable can only exist as a complete value (year, month and day).
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform