Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Question about report dates
Message
De
23/09/2000 12:51:18
 
 
À
23/09/2000 08:59:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00419729
Message ID:
00420195
Vues:
28
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform