Last day of each month

[#1]

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?

[vinafidalgo · Accepted solution]

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]

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]

hi skraba,

     what will date#() will do?