Hello. I am new to crystal and trying to create a report against an ingres database. I can run it without searching for a date but when i enter a date parameter i get an invalid date error. The dates in the database are stored as dd-mmm-yyyy and the parameter field is dd/mm/yyyy. How can I match these to get rid of the error.
vtcrystal (BOB member since 2016-07-14)
here you have two options to resolve this either you change the date format in backend to get the correct format like parameter or in selection formula change the dateformat before comparing the values… in backend TO_CHAR and TO_DATE functions need to use to get into correct format. in crystal report you have to use totext function or date() functions… by doing some workaround this can be resolved… in different methods…
surya.g 
(BOB member since 2009-11-24)