ShowAll Questionssorted byDate Posted
billgreenhaw

# Adding a year to date and day to last day of the month

Hi,

I need to take a date field and update another date field to be the original date + 1 year.  And also take the day from the original date and make it the last day of the month.

Can I do this by workflow? Or do I need to write some APEX for it?

Thanks.

nylon

This formula returns the last day on the month, probably.

DATE(YEAR(Date2__c)+IF(MONTH(Date2__c)=12,1,0),MOD(MONTH(Date2__c),12)+1,1)-1﻿

TrimbleAg

Well, part one is easy, use a formula date field and do a:

Date1_c + 365

Now part 2 is where your going to have issues.... I dont see how to do this, but I am sure people out here will know, but it would require a trigger I would imagine.

PB

Cloud on Fire
Date1__c + 365 won't exactly work in a leap year, would it? You could try something like this: DATE(YEAR(Date1__c)+1,MONTH(Date1__c),CASE(MONTH(Date1__c),1,31,2,28,3,31,4,30...)) If you need to set to Feb 29 in leap years then you'll need to put an IF in the result for 2 in the CASE statement
nylon

This formula returns the last day on the month, probably.

DATE(YEAR(Date2__c)+IF(MONTH(Date2__c)=12,1,0),MOD(MONTH(Date2__c),12)+1,1)-1﻿

This was selected as the best answer