Recent content by CoachBarker

Yes I got it fixed, turns out substring isn't valid in SSRS, so I got by on a left, mid and then the rest of the string.

Are there moderators here who could move the post to the corrrect forum?

On the chance that maybe there was someone here that could help, I assumed an expression was an expression. Not a lot of xamples on the web and the books I got are not much better :o I am the lucky one at work who was chosen to learn how to do these reports on the fly.

In the expression box for the textbox if I use your version as =IIF (Len(Fields!pickup_dt.Value) = 8,dateserial(left(Fields!pickup_dt,4),mid(Fields!pickup_dt,5,2),right(Fields!pickup_dt,2)),false condition) I get a syntax error on condition When I run the report I get...

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) =...