Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to reset a date or date/time to empty?
Message
From
02/09/1999 19:51:41
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00260884
Message ID:
00260922
Views:
16
>>Steve,
>>
>>If you could show us your code that errors on you it would be much easier to help you out.
>>
>>Keep in mind that teh delimiters for date and datetime values are the curly braces {}. So to replace a datetime field named Today with a blank would be;
>>
>>REPLACE Today WITH {}
>
>Technically, shouldn't that be {//:} so that its an empty DATETIME type? For a variable, setting it to {} would make it a DATE type (D), not a DATETIME type (T).

If its a datetime and you replace it with {} it will still result in a correct empty datetime field.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform