I had this issue a week ago, the field was a date in the database, everything well defined and I had exactly the same issue. Crystal didn't want to recognize the date format, it was set as string.
So in the SQL, it forced the date to characters
to_char(ACT1.DATESTAMP,'DD/MM/YY HH24:MI:SS')...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.