Remove unwanted value

[renjithpl]

Hi All,

I have code like below, when i reload this, i get WK as default.

'WK ' & Week(Op_Date) as Week_Name,

I want to remove this.

Regards

Renjith

[#2]

Hi,

I believe you need to give command separately for both headers like below

WK as Week_Name

Week(Op_Date) as Week_Name

I hope it would help you.

Regards

Nikhil

[senpradip007]

Hi renjitpl,

can you please ellaborate your question.....

[renjithpl · Accepted solution]

I have used following code for my query, It works

IF(len(trim('WK ' & Week(Op_Date)))>3, 'WK ' & Week(Op_Date)) as Week_Name