Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strictdate Unhappiness!
Message
From
11/12/2001 15:15:57
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00592889
Message ID:
00592901
Views:
23
>>Hello Everyone,
>>
>>I would appreciate any assistance on this one. I have created a report based on parametized view. The view prompts for a date range. When I run the report
>>the following is the error I receive.
>>
>> Error 2032: Ambiguous Date/DateTime constant. Use the format
>> ^yyyy-mm-dd[,][hh[:mm[:ss]][a|p]]
>>
>>Thanks...
>
>It is expecting you to enter something recognized as a Date. I gather your parameterized view had something like:
>
>Table.DateField = ?vp_DateEntered
>
>If you are keying this in you might try:
>
>Table.DateField = CTOD(?vp_DateEntered)


Bret,

In the view my parameters are setup as [Date] in the View Parameters screen. [VFP6.0]. Would I still need the CTOD on the parameters. With regards to date field in the table, I have [Set Date to YMD], [Set Century On], and [Set Strictdate To 1] in my main program.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform