I'm a Crystal newbie trying to modify a report that is using SQL expressions. I need 4 additional expressions that are basically identical to 4 that already work so I copied them. The SQL database field referenced in the expression is a smalldatetime. The original expressions return datetime information. The ones I copied and modified are returning string data. I don't find where the data gets formatted. When I place the SQL expression on the report it goes as a string. Viewing the original ones show datetime.
This is an original SQL expression. I change the '11' to '31' in mine.
(Select "PED"."MP_StartDate"
From PED
Where "PED"."Deleted" = '0' and "PED"."MP_IP" = '11')
Thanks in advance for any assistance you can provide.