Display Null if Date has a specific value

[Raghuvir]

hi all,

we are using DB2 as our data source, we have a date field in the format of yyyy-mm-dd when the value in the date field is 0100-01-01 we need to display NULL in the reports.

how we will achieve this ? please guide me with the same.

Regards

[Lynn]

How about a conditional style?

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_8.4.0/com.ibm.swg.im.cognos.ug_rptstd_fin.8.4.0.doc/ug_rptstd_fin_id3759cr_rptstd_modrep_highlight_data_con.html%23cr_rptstd_modrep_highlight_data_cond_styles

[raj_aries81]

hi all,

we are using DB2 as our data source, we have a date field in the format of yyyy-mm-dd when the value in the date field is 0100-01-01 we need to display NULL in the reports.

how we will achieve this ? please guide me with the same.

Regards

How about using a simple case statement... Case when extract(year,[date dataitem])=0100 then null else [dataitem] end

[Raghuvir]

How about using a simple case statement... Case when extract(year,[date dataitem])=0100 then null else [dataitem] end

yah did that. Thanks for the tip.