I have put a search field on my grid. A search from Date to Date. I am using a SQL databse that uses the date/time field. I am using the ODBC_DT_TO_D() so that I can take the date, but when I search nothing comes up on the web page.
Is the date "yyyy.mm.dd", after I use the ODBC_DT_TO_D()function?

The date I search on is mm/dd/yyyy, would that be a problem? I am using the drop down calendar in the grid search.

I cannot figure this out.