The client wants to add a week field in the workbook. The week format should be week number/month/year
Solution
Add a formula field to see the week.
Add the below formula to see the week number.
‘W’||to_char({trandate},’IW’)||’/’||to_char({trandate},’MON’)||’/’||to_char({trandate},’YYYY’)
