April 4, 2012 at 3:02 am
Hi All,
I have the following expression, where if there is no date for the Planneddate then the Report should display the ActualDate; but at the moment, if there are neither days it displays 12:00am but I need it just to display blank. Would anyone know how to perform this please
=FormatDateTime(IIF(IsNothing(Fields!Planneddate.Value), Fields!appl_status_date.Value, Fields!ActualDate.Value))
Thank you in advance!
April 4, 2012 at 3:07 am
Hi
You'll need to nest another IIF, something like this:
=FormatDateTime(IIF(IsNothing(Fields!Planneddate.Value), IIF(IsNothing(Fields!appl_status_date.Value)," " , Fields!ActualDate.Value)))
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 4:43 am
Thank you for your reply!
I used the following expression and it worked
=(IIF(IsNothing(Fields!Planneddate.Value), Fields!appl_status_date.Value,IIF(IsNothing(Fields!ActualDate.Value),"",Fields!ActualDate.Value)))
Thank you!
April 4, 2012 at 4:45 am
No Probs 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply