I have a report that shows employees that have worked at least 6 months from the date the report is run. I am creating a derived field to display their Coverage Begin Date as being the 1st day of the following month. So, if my company seniority day is 04/03/2005 than my Coverage Begin Date would be 11/01/2005. The Add_months function can get me 11/03/2005 but I need it to display the first day of the 7th month. The Last_Day function works great for this but I need it to show the First day not the last. Any ideas on an easy way to do this?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.