General information
Category:
Coding, syntax & commands
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only