Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question about report dates
Message
From
23/09/2000 12:51:18
 
 
To
23/09/2000 08:59:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00419729
Message ID:
00420195
Views:
29
>Hi Trey.
>Nope. After deleting the ctod() now I got an Operandor/Operator type mismatch message, BUT, if I write the following in the command window:
>
>date1=ctod("09/17/2000")
>date2=ctod("09/19/2000")
>
>I can browse my view just fine. How can adapt this to the view's filter?
>
>Thanks for your time.
>
>Ulises

OK, couple more questions :)

Since the above works, I'm assuming the data type of the Ventas.fechaonly field is date.

So the problem must be with however the date1 and date2 variables are populated before being used by the view.

CTOD() used on a non-date variable results in the first error - Error 11: Function argument, value, type or count is invalid
Comparing a date type to a character type results in the above error - Error 107: Operator/operand type mismatch.

I'm guessing that at the point the date1 and date2 variables are being used by the view, they are neither of date type (for the field=var attempt) nor of the correct date string format (for the field=CTOD(var) attempt).

I would set a breakpoint in the code before the view is requeried and see what data type the date1 and date2 are.

HTH
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform