Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
AOA
I HAVE TWO FIELD
MAX_YEAR | MAX_MON |
---|---|
2013 | MAY |
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
TRY THIS
=DATE(MonthEnd(Date#(MAX_MON & '-' & MAX_YEAR,'MMM-YYYY')),'DD-MMM-YYYY')
SEE ATTACHEMENT
TRY THIS
=DATE(MonthEnd(Date#(MAX_MON & '-' & MAX_YEAR,'MMM-YYYY')),'DD-MMM-YYYY')
SEE ATTACHEMENT
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
thnks of all who replied... love u guys