Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Silly question but it is Friday
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01596530
Message ID:
01596532
Views:
71
>>How do I clear a date field and a datetime field
>
>Mechanically, you can do it like this if it's in a table or cursor:
>
SCATTER NAME xyz BLANK
>REPLACE dDate     WITH xyz.dDate
>REPLACE tDateTime WITH xyz.tDateTime
>RELEASE xyz
>
>Or you can use the blank forms directly:
>
thisForm.myDateControl.Value     = CTOD("  /  /    ")
>thisForm.myDatetimeControl.Value = CTOT("  /  /     :  :   AM")
>REPLACE dDate     WITH CTOD("  /  /    ")
>REPLACE tDateTime WITH CTOT("  /  /     :  :   AM")
>
>You can also use the BLANK command if it's in a table:
>
BLANK dDate, tDateTime
>
>And if you need it set back to NULL, you can use:
>
REPLACE dDate     WITH {  /  /  }
>REPLACE tDateTime WITH {  /  /     :  :   AM}
great guy to have around

Thanks a lot
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform