I have a field coming into a report from SQL Server 2005 that is a date in a string format. I am using an IIF statement to format the string for the report so when it exports to excel it still reads in it's proper format. This is the IIF:
=IIF (Len(Fields!pickup_dt.Value) =...