How to replace a date value in date column with blank space

building semantic layer
1

Hii… I am using webi 4.1 version. In my report i have date column name effectivedate. In this there are many date that are coming dynamically while running the report. I need to replace one date value with blank space. Values in Effective date column are in date format.
Example
Effectivedate
6/13/09
6/13/09
6/13/09
3/16/08
3/21/08
6/7/08
3/16/08

Now i need to replace 6/13/09 date with blank space and needs to keep all values remain same. I need this below output.
Effectivedate

3/16/08
3/21/08
6/7/08
3/16/08

shikhaaggrawal (BOB member since 2015-04-29)

2

Hi,

you can try this : create a variable EDate

If Not(Effectivedate = 6/13/09) then Effectivedate

regards

TomiLee (BOB member since 2015-07-01)

3

Will it always be the same date?

4

Or you can use replace function as replace(6/13/09,"")

surya_sudheer :india: (BOB member since 2006-11-01)

5

Hi,
You can use alerter as well.
When ever you got 06/13/09 that time use blank space for that.

In alter you need to set CELL CONTENTS=‘06/13/09’ that place blank space.
b.png

kevin4813 (BOB member since 2015-06-29)