Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
aut_phil
Creator
Creator

Last Monday of Month

Hi,

can somebody help me in calculating the last monday of a given month?

Thx in advance!

-Phil

1 Solution

Accepted Solutions
swuehl
MVP
MVP

=Weekstart(MonthEnd( Makedate(YourYearField, YourMonthField) ))

View solution in original post

4 Replies
andrespa
Specialist
Specialist

Hi Philipp,

date((WeekStart(yourDate) ), 'D-M-YY') AS FirstDayWeek

Best regards,

Andrés

swuehl
MVP
MVP

=Weekstart(MonthEnd( Makedate(YourYearField, YourMonthField) ))

View solution in original post

aut_phil
Creator
Creator
Author

Thank you!

You Guys are awesome .

raajaswin
Creator III
Creator III

Hi Philipp,

This is it

=Date(WeekStart(MonthEnd(date#('03/09/1993','MM/DD/YYYY'),0)),'DD/MM/YYYY')

in the date given you can give your field also