Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi renjitpl,
can you please ellaborate your question.....
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