#DateWhereItemComment
219 Apr 2011 @ 10:28 PDTRobG's blogDetermining Month-End Date for a Date Dimensionsame results as @bmcclernan 's solution for last day of previous month would be SELECT DATE-extract(DAY from DATE); that may make more sense in reading, but I suppose it'd be rather worst in ...
104 Mar 2011 @ 04:19 PSTRobG's blogDetermining Month-End Date for a Date DimensionI would have used a more generic and reusable expression like the following: ADD_MONTHS(calendar_date - EXTRACT(DAY FROM calendar_date)+1, 1) - 1 This way you may use any date field from any ...