Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DateTime field
Message
From
21/01/1999 11:18:40
 
 
To
21/01/1999 11:05:38
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00178483
Message ID:
00178492
Views:
30
Hiya John ----

You could, using the Valid event, test for "12:00:00 AM" with the following:
(Assumes tDateTime is the ControlSource)
IF TTOC(tDateTime,2) = "12:00:00 AM"
   WAIT WIND "Hey!  No time entered!"
   RETURN .F.
ENDIF
RETURN .T.
>i have three fields in my table date , hour and minute. but instead of keeping three fields , i am more interested to keep single datetime field. but problem in datetime is if user does not enter time ,then it takes vfp's default time(midnight time). what i should do ? should i keep three fields separate?because hour and minute fields would be character and it requires validations for proper value
>thankyou
>john still
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform