CMS ODBC Date Format 1

[SimonHunter]

I'm using ODBC to connect to CMS from Excel using ODBC-Direct.

Unfortunately I can't seem to get the any date criteria to work.

Eg SELECT * FROM dagent WHERE row-date = '14/sep/2005' gives an ODBC Call Failed error.

Any help appreciated!!!

 

[nohuhu]

SimonHunter,

try using iso date format: 2005-09-14.

 

[SimonHunter]

Thanks - I figured it out shortly after posting the question. Funny how that often happens!

 

[nohuhu]

SimonHunter,

it's understandable. you write down your question and thus force your brain to think it over from other side. and very often that leads to a solution, just a minute after you pressed 'send' button.