>HELP!!
>
>I have a remote view that pulls all records for a specific date such as today 3/4/02. MS SQL is saving the date as a datetime such as 03/04/02 2:00 PM. My view always comes up empty unless I go into MS SQL and erase the time portion of the date time field. When I do this everything works. I tried all combinations of CTOD and DTOC. I think I need to use an SQL date function of some sort.
>
>Any ideas?
>
>Thanks!
>
>Jose
Shot in the dark: did you try ttod() function as well?
If it's not broken, fix it until it is.
My Blog