Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

aut_phil
Not applicable

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
Not applicable

Re: Last Monday of Month

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

4 Replies
andrespa
Not applicable

Re: Last Monday of Month

Hi Philipp,

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

Best regards,

Andrés

swuehl
Not applicable

Re: Last Monday of Month

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

aut_phil
Not applicable

Re: Last Monday of Month

Thank you!

You Guys are awesome .

raajaswin
Not applicable

Re: Last Monday of Month

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