# Rounding a Date to the 1st Day of the month

• February 24th, 02:49 PM
Mikey
Rounding a Date to the 1st Day of the month
Hi there i'm having problems trying to get a calculation to work. 2
fields an End date and a Renew Date. The end date is manually entered
and the renew date calculates the end date + 365. What i need it to do
is to have it always calculate to the first of the month. i.e. - End
Date = 2/24/2004 Renew Date= 2/01/2005. Is there any easy way to do
this. any help is definitely appreciated.
• February 24th, 03:12 PM
Kevin
Re: Rounding a Date to the 1st Day of the month
Mikey P wrote:

Using a strict 365 day addition (i.e. not accounting for leap year - Feb
29, 2004 would have a renew date of March 1, 2005):

Calc field returning date: Renew Date = Date(Month(End Date + 365), 1,
Year(End Date + 365))

Or, to account for leap years (Feb 29, 2004 would have a renew date of
Feb 1, 2005):

Renew Date = Date(Month(End Date), 1, Year(End Date) + 1)

(I may have the order of month and day mixed up, but that's the right
function)

• February 24th, 03:19 PM
Ted
Re: Rounding a Date to the 1st Day of the month
Try this..

Date( Month(EndDate), 1 , Year(EndDate) + 1 )

But a EndDate that is 2/1/2004 will give you a RenewDate of 2/1/2005 your
losing the 23 day grace period as in your example.

Ted

"Mikey P" <com> wrote in message