Welcome aboard.
The best solution to this is a lookup to a "time dimension" table or Data Set. Two columns in such a table are typically MonthFirst and MonthLast dates.
Transformation Logic
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: