Creating the 1st day of the month field

[scotton]

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?

TIA,

Sarah

 

[CharlesCook]

Could you add 6 months then do a last_day + 1

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining