Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rounding the date or setting day to the 1st of month

Status
Not open for further replies.

cunner26

Technical User
Nov 18, 2002
9
CA
For this report employees become eligible for our plan the 1st of the month following three months of service.

I currently have the following formula

Dateadd ("m",4,{eepaystatus.orighiredate})

This formula has allowed me to add 4 months to the original hire date of the employee but I am unable to either round the date down to the first of the month or set the date to the 1st.

Can you please help me with this,
 
DateVar HirePlus4 := Dateadd ("m",4,{eepaystatus.orighiredate});
Date(Year(HirePlus4),Month(HirePlus4),1)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top