LAST DATE OF A MONTH

mcs@rajesh · Post by **mcs@rajesh** » Tue Mar 04, 2008 9:40 am

HI

Month_date is the one of the column in my source which contains only the name of the month for ex"January"."March"....
I need to get the last date of these months
for ex "January"="2008-01-31" likewise i need to calculate the last date for all the mont in the similar fashion.
Guide me if this can be achieved in DS.

Thank you

kcbland · Post by **kcbland** » Tue Mar 04, 2008 9:52 am

TIME dimension works great (really the TIME subject area). A DATE grain table, a MONTH grain table, a QUARTER grain table, and a YEAR grain. You can reverse lookup on month name and year to the MONTH table. Your month table would have many attributes describing the month, which probably should include the last day in the month as a date.

crouse · Post by **crouse** » Tue Mar 04, 2008 10:57 am

or, find the first day of the next month and subtract 1.

(And as Ken mentions, this would be good meta data to have in your Date/Time dimension, since you don't want each developer coming up with his/her own way of deriving it, if possible)

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 5:15 pm

LastDayCurrentMonth, FirstDayNextMonth, ThisDayNextMonth, LastDayLastMonth, FirstDayLastMonth, ThisDayLastMonth are all good columns to have in a time dimension table.