Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

1 Solution

Accepted Solutions
vinafidalgo
Partner - Creator
Partner - Creator

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.

View solution in original post

4 Replies
vinafidalgo
Partner - Creator
Partner - Creator

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.

alexandros17
Partner - Champion III
Partner - Champion III

Use MonthEnd() function, take a look in help

Colin-Albert

Dates seem to cause many issues judging by the posts here.

This link gives a good overview on dates in QlikView.

Get the Dates Right

dineshkumar
Contributor III
Contributor III

hi skraba,

     what will date#() will do?