topic Re: expression to Replace a blank date with current DATE in ssrs in Report Server

expression to Replace a blank date with current DATE in ssrs

M_nwadibia — Mon, 26 Dec 2022 20:55:31 GMT

Hello,

I have this weekly report I distribute every monday. I find situations where dates are blank as displayed below and all data is displayed in the previous week bar. I need an expression to replace the blank date with current date so that I can have the fourth bar instead of 3 bars as shown below. Your suggestions will be appreciated.

Re: expression to Replace a blank date with current DATE in ssrs

ouaelaam — Mon, 26 Dec 2022 19:46:33 GMT

You can create a simple calculated date column with a formula like below :

Date_Adjusted =
IF ( ISBLANK ( 'Table'[Date] ), TODAY (), 'Table'[Date] )

✔️

If this post is helpful, please consider marking it as a solution so that other users may find it more easily.

Re: expression to Replace a blank date with current DATE in ssrs

M_nwadibia — Mon, 26 Dec 2022 20:28:19 GMT

Oh I did not mention that this is SSRS expression and not power Bi. Thanks

Re: expression to Replace a blank date with current DATE in ssrs

ouaelaam — Mon, 26 Dec 2022 20:51:59 GMT

Ah sorry I thought it was Power BI.

Re: expression to Replace a blank date with current DATE in ssrs

TOK — Mon, 02 Jan 2023 16:17:27 GMT

Hi M_nwadibia,

this should work: =iif(Fields!Date.Value = Blank(), Today(), Fields!Date.Value)

Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ

Re: expression to Replace a blank date with current DATE in ssrs

M_nwadibia — Tue, 03 Jan 2023 18:20:58 GMT

Hello,

I tried implementing this but I get this error below . How can I clear the error?

iif(Fields!WeekStart.Value = Blank(), Today(), Fields!WeekStart.Value)

Re: expression to Replace a blank date with current DATE in ssrs

TOK — Thu, 05 Jan 2023 10:56:19 GMT

Hi M_nwadibia,

sorry, my fault. Blank doesn't work in ReportBuilder.
Please try the following:

=iif(cstr(Fields!WeekStart.Value) = "", Today(), Fields!WeekStart.Value)

Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ