On Wed, Mar 18, 2009 at 6:37 PM, Sytze de Boer <[email protected]> wrote: > Hi > > I know how to do cmonth(date()) and various derivatives thereof > How do convert a number to a month ? > > This is be done in a select statement where 1 field is (say 200804 or > 200805) > The numbers are consistent yyyy mm, and I'm only concerned with the month > > I appreciate all pointers ----------------------------------------
I would make a DateDimension table that would join to ANY needed table for getting any type of date dimension you need. Date, PKey MonthNum, MonthName, MonthAbbr, PeriodNum, PeriodYear, Quarter, Year, DOW, CDayOfWeek I have been doing this for years for DW reporting. -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
