I am a relative newby to CR.
I'm trying to modify a report created by someone else. The report uses 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 as I expected. The ones I copied and modified are returning string data. I don't find where the data gets formatted. I would think that selecting a smalldatetime field would return smalldatetime or datetime data. When I place my SQL expression on the report it goes as a string. Viewing the original ones show datetime. How can I get it to return datetime?
This is one of the original SQL expressions. I changed 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.
Brenda
I'm trying to modify a report created by someone else. The report uses 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 as I expected. The ones I copied and modified are returning string data. I don't find where the data gets formatted. I would think that selecting a smalldatetime field would return smalldatetime or datetime data. When I place my SQL expression on the report it goes as a string. Viewing the original ones show datetime. How can I get it to return datetime?
This is one of the original SQL expressions. I changed 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.
Brenda
