topic Re: Month End in QlikView

Month End

NavinReddy — Fri, 14 Feb 2014 03:43:31 GMT

Dear All,

=date(date(MonthEnd(today()),'dd/mm/yyyy'),'dd/mm/yyyy')

I am using this to Disply monthend date but im getting 28/59/2014 like this format

could some one help me disply this monthend date

Thanks In Advance

Niranjan

johnca — Fri, 14 Feb 2014 03:47:43 GMT

=date#(MonthEnd(Today()),'dd/mm/yyyy') will return 2/28/2014.

Note the # sign.

NavinReddy — Fri, 14 Feb 2014 03:50:39 GMT

=Date(MonthEnd(Date(Date(Today(),'YYMM'),'MM-YYYY')),'DD/MM/YYYY')

this will return my format

Sokkorn — Fri, 14 Feb 2014 03:51:56 GMT

Hi Niranjan,

'dd/mm/yyyy' -> mm here will consider as minute. For date format it should be capital letter 'MM'.

Let try this =date(date(MonthEnd(today()),'dd/MM/yyyy'),'dd/MM/yyyy')

Or simply =date(MonthEnd(today()),'dd/MM/yyyy')

Regards,

Sokkorn

johnca — Fri, 14 Feb 2014 04:01:47 GMT

A more simple answer would be:

=date(MonthEnd(Today()),'DD/MM/YYYY')

This also returns 28/02/2014.

(I misread your format the first time)