Hello all. I need to get the last day of a month based on the months name. I dont want to have to do a case statement i would like to use, if possible,
which i use to get the last day of the current month. I just cant wrap my head around how to pass the datename or even the date number such as 1 for january and have the query return the last day of january. To add a dimension i also have the year so i would pass something like January 2012 or 1-2012...is this possible?
Thank you for your help.