Week Name from Date

[MPS]

Hello everyone,

How do I show the Week Number from the below expression. No its shows the Week end date & year
​
=Date(WeekEnd([Estimated Pre-Approval Date]),'DD/MMM/YY')

now its shows as for current week -- 24/Jul/21. But i want as "Week 24"

Please help

[Kushal_Chawda]

@MPS  did you try , 'Week ' &  week([Estimated Pre-Approval Date])

[AshwinDaniel]

Hi @MPS ,

You shall check the below link, if you are looking for week Number:

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...

If you would like to check the week starting or end then you are right/good.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...

Hope this will help!

Regards,