query

[spindle]

I tried running a query which I copied from one computer to another, but I get the following error message when I do: "date does not exist." I can run the query on the original computer just fine, but not on the other. Any suggestions as to what I can try would be most appreciated.

Thank-you,

Spindle

 

[jbpelletier]

Check the windows date format (control panel,regional setting, date)... probably computer have different format.

jb

 

[spindle]

Thanks for your response, but I already considered that. The date formats in my tables and in Windows are the same: yyyy-MM-dd.

 

[spindle]

jb,

thanks again for your advice. what i failed to do was check the date format on the computer where the query was saved originally - it turned out to be different than the format on the second computer, which i had checked. once i changed it and resaved the query, it worked fine.

cheers