
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Last day of each month
Hi to all of you,
I'm new to QlikView and I'm having some troubles dealing with dates.
How can I get the last day of each month?
- Tags:
- new_to_qlikview
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, welcome to QlikView.
Please try this function:
MonthEnd(DATE) -> this one shows the last day of the month of the date you've specified.
MonthStart(DATE) ->this one shows the first day of the month of the date you've specified.
Please replace the word DATE to your Date field.
If you have any other questions, please reply this post.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, welcome to QlikView.
Please try this function:
MonthEnd(DATE) -> this one shows the last day of the month of the date you've specified.
MonthStart(DATE) ->this one shows the first day of the month of the date you've specified.
Please replace the word DATE to your Date field.
If you have any other questions, please reply this post.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use MonthEnd() function, take a look in help


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dates seem to cause many issues judging by the posts here.
This link gives a good overview on dates in QlikView.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi skraba,
what will date#() will do?
