Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dates in Expression Builder
Message
From
02/06/2005 18:39:11
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
02/06/2005 16:12:03
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01019562
Message ID:
01019625
Views:
26
>I am using getexpr to create a character variable with a date. When I enter the data, it must have quotes around it. But when I try to do CTOD with the variable all I get is dashes. I think it is because of the quotes around my data in the variable. I am not sure how format my data in the expression builder so I don't get the quotes. Help!

You need to format it the way your set("date") requires. IOW, the problem is in the CTOD(), which conforms to the current date setting. You may set the date format to whatever you want before getting into the expression builder, and keep it at least until your CTOD() hasn't returned a non-empty date.

Keep in mind that Set Date is scoped to the current data session. So, check what it is before you Getexpr To your variable. It would also be nice to restore the setting when you're done.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform