Re: odbc datetime and crytal info.

I am also having probles with Crystal Reports 6 and Informix dates. I am using a prompt for a selection on a date field. Crystal insists that the user enter 'date(yyyy,mm,dd)' eg date(1998,07,03). However, crystal cobverts this to 'Jul 3, 1998' in the sql that is passed to Informix, which of couse is not a valid informix date format. I have tried various date setting in crystal and windows without any success. I have submitted a tech support to seagate. If I get anything useful back from them, do you want me to forward it to you? robmcq@my-dejanews.com wrote in message <6ngpcl$n6b$1@nnrp1.dejanews.com>... >We are having a problem with the datetime in crystal info ODBC generated sql. >It is being rejected by INFORMIX on datetime fields. > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum