SSRS Parse Date Error in SSRS Expression

Question

Any idea why getting an #Error using the code below when the field fp_firstshifttimein does not contain value. But when the field contains value, it works.

=IIF(IsDate(Fields!fp_firstshifttimein.Value), 
DateTime.Parse(Fields!fp_firstshifttimein.Value).addDays(8), Nothing)

Same issue with the code below:

=IIF(IsNothing(Fields!fp_firstshifttimein.Value), Nothing,
 DateTime.Parse(Fields!fp_firstshifttimein.Value).addDays(8))

Thanks all.

score 2 · Accepted Answer · edited Jun 09 '16 at 14:36

2

I found out that SSRS evaluates each part of the function before the report is executed. I tried the code below. It worked.

=IIF(IsDate(Fields!fp_firstshifttimein.Value),
DateTime.Parse(iif(IsDate(Fields!fp_firstshifttimein.Value) ="1",
Fields!fp_firstshifttimein.Value,"01/01/1900")).addDays(8), nothing)

edited Jun 09 '16 at 14:36

Andy K

4,944
10
53
82

answered Jun 07 '16 at 02:25

dalday

31
1
6

score 1 · Answer 2 · answered Jun 06 '16 at 13:25

1

Can you have a try with this?

=IIF(Fields!fp_firstshifttimein.Value is nothing, nothing, DateTime.Parse(Fields!fp_firstshifttimein.Value).addDays(8))

answered Jun 06 '16 at 13:25

Andy K

4,944
10
53
82

score 0 · Answer 3 · answered Jun 06 '16 at 15:53

0

Use the DateAdd function like this:

=IIF(IsNothing(Fields!fp_firstshifttimein.Value), Nothing,
    DateAdd("d", 8, Fields!fp_firstshifttimein.Value))

answered Jun 06 '16 at 15:53

StevenWhite

5,907
3
21
46

SSRS Parse Date Error in SSRS Expression

3 Answers3