How to convert a Month to Month end date

[#1]

Hi,

How can i convert the month (For Ex:APR-15) to be converted to the Month end date (Ex:04/30/2015).

[MK_QSL · Accepted solution]

Date(MonthEnd(Date#(YourMonthYearField,'MMM-YY')),'MM/DD/YYYY') as YourRequiredField