Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MPS
Contributor III
Contributor III

Week Name from Date

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

Labels (1)
2 Replies
Kushal_Chawda

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

AshwinDaniel
Contributor III
Contributor III

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,