So the requirement here is to find out whether there is leap year date (ie, 2/29/xxxx) between a date range using Formula in Salesforce.

We have two dates for our custom Object, Start Date and End Date, and the date range is usually within a year, for example:
1) If Start Date is 7/3/2003, End Date is 4/4/2004, then the Formula Output should be "YES" because there is a leap year date(2/29/2004)
2) If Start Date is 2/1/2016, End Date is 1/10/2017, then the Formula Output should be "YES" because there is a leap year date(2/29/2016)
3) If Start Date is 4/2/2004, End Date is 2/15/2005, then the Formula Output should be "NO" because there is no date for leap year for the given date range

Thanks a lot for the help!

Hi is there any video tutorial which help us learning the set up of live agent

Hello

 

I have a field where a Full Name is entered - I need to split this into a First Name field and a Last Name field

 

I have created the fields - I need help on the formula

 

In many cases there are 4 entries

John abott-gacey

Mary Smith-Felch

Sam M. Wall

 

Thanks