Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
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