Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strictdate and param views
Message
From
12/01/2000 11:15:43
 
 
To
07/01/2000 20:25:13
Jacci Adams
Lindsay-Adams Consulting
Louisville, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00314833
Message ID:
00317003
Views:
22
I have been (still am) batteling the same kind of problem. So far the best work-around I have found is to use the calander class to provide the parameter. I have another form where the calander is inappropriate and run into the 'ambiguios date' error. I re-coded that to format the date into strict date format, basicly, I check the format of the data entered, it could be text or date, if numeric, it is a date, then i take it apart(year_part, month_part, day_part) and put it back together with DATE(year_part,month_part, day_part)
Ugly, ungainly but it works, just so long as the users always use dd/mm/yyyy (offical date format)or else there will be no records found (day < 12) or invalid field (day >12)
Previous
Reply
Map
View

Click here to load this message in the networking platform