Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Use MonthEnd() function, take a look in help
Dates seem to cause many issues judging by the posts here.
This link gives a good overview on dates in QlikView.
hi skraba,
what will date#() will do?