Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

last day of month

AOA

I HAVE TWO FIELD

MAX_YEARMAX_MON


2013MAY

WHICH IS THE MONTH AND YEAR,

  WHEN DATA WAS LOADED

NO I WANT THE LAST DAY OF THAT MAX MONTH IN PROPER DATE FORMATE

(i.e 31-MAY-2013)

I TRIED

=MAKEMONTH(MAX_YEAR,MAX_MONTH,31) NOT WORKING....

ANY ADVICE

1 Solution

Accepted Solutions
Not applicable
Author

TRY THIS

=DATE(MonthEnd(Date#(MAX_MON & '-' & MAX_YEAR,'MMM-YYYY')),'DD-MMM-YYYY')

SEE ATTACHEMENT

View solution in original post

3 Replies
Not applicable
Author

TRY THIS

=DATE(MonthEnd(Date#(MAX_MON & '-' & MAX_YEAR,'MMM-YYYY')),'DD-MMM-YYYY')

SEE ATTACHEMENT

Sokkorn
Master
Master

Hi,

Try this

=MakeDate(2013,Month(Date(Date#('May','MMM')))) ==> Returen 01-05-2013

=MonthEnd(MakeDate(2013,Month(Date(Date#('May','MMM'))))) ==> Return 31-05-2013

Regards,

Sokkorn

Not applicable
Author

thnks of all who replied... love u guys