I have a report where I am using the following formula:
CASE WHEN PEDTEDC.Qry = 'PEDTEDC' AND Max(PEDTEDC.ValueInfo) IS NOT NULL
THEN CONVERT(VARCHAR(10),PEDTEDC.ValueInfo, 112) END AS EDC
I need to convert the results (date field) to print out at 09-18-2014. I tried using the formula above but this is not working.
Instead it is printing out as
Can someone help?