Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax for finding a particular record
Message
From
07/12/2006 10:09:16
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01175528
Message ID:
01175638
Views:
6
>>>ldTestDate = {01/04/1995}
>>
>>Yes, Sergey, you've pointed out this before but whenever I use that construct I get the message:
>>
>>"Ambiguous date/datetime constant. Use the format {^yyyy-mm-dd ..." (as your 2nd ex.)
>>
>>or for some reason my date doesn't get stored as a date. I've never had any luck with that so I continue to use the old dBASE code that I trust, the way I learnt. I didn't want the same error messages to beset the newbie, Bilal.
>
>SET STRICTDATE TO 0
>
>>>* Even better
>>>ldTestDate = {^1995/04/01}
>>
>>Maybe so but I'm used to dates in British format (as I suspect Bilal is :-)
>
>Very weak excuse for not writing proper code.

Since when has CTOD() not been proper code? If it isn't why don't they get rid of it or mark it as "included for backward compatibility"? OK, it can be ambiguous if StrictDate = 2, but you yourself said set it to 0, in order for ldTestDate = {01/04/1995} not to generate an error

Also, I don't recall StrictDate existing before VFP7 (I may be wrong). I don't know what version we're talking here, so using the LCD can't be harmful
- 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