• ltremaine
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 0
    Replies

I have a custom Date field called 'Loss Date' (Loss_Date__c). 
I have another Custom formula (date) field called 'SOL Date' (SOL_date__c)
The 'SOL Date' needs to equal a date exactly 2 years in the future from the Loss Date (accounting for Leap years)

The formula I have is below.

Any Ideas where its wrong?

 

 

DATE(Year(Loss_Date__c)+ floor((MONTH(Loss_Date__c) + 24 -1) / 12), mod(MONTH(Loss_Date__c) + 24 / 12) + 1, day(Loss_Date__c)) - 1

Contact for these jobs: 


Ronni Barb

Tel:  614.754.7273
Email:  ronni.barb@avancos-global.com
  Let's Connect!
  www.linkedin.com/in/ronnibarb
      

  These roles are full-time, permanent opportunities with a global management consulting firm.
  

    CRM Salesforce.com Consultant

    Location:           Location Negotiable

    Travel:              80% (Monday - Thursday)

    Key responsibilities may include:
    • Supervising process and functional design activities
    • Creating functional requirements as an input to application design
    • Developing and testing detailed functional designs for business solution components and prototypes
    • Supervising application build, test, and deploy activities
    • Planning and executing data conversion activities (e.g., test data)
    • Driving test planning and execution

    Basic Qualifications:

        * Bachelors Degree
        * 2+ years of Salesforce.com (SFDC) systems integration and/or implementation experience
        * 2+ years of application requirements gathering and design, including process mapping and gap analysis

    Preferred Skill Requirements:

        * Ability to travel 80%
        * Experience with Microsoft Dynamics or Oracle on Demand
        * Basic project management experience

    Primary Locations: USA-IL – Chicago,  USA-NJ - Florham Park, USA-NY -New York, USA-GA - Atlanta, USA-DC - Washington, DC, USA-TX - Dallas, USA-CA - San Francisco, USA-VA - Reston, Minneapolis-MN

    Other Locations: USA-PA - Philadelphia, USA-TX – Houston, USA-MA - Boston, Denver-CO, Detroit-MI

     

    CRM Salesforce.com Analyst

    Location:           Location Negotiable

    Travel:              80% (Monday - Thursday)

    Key responsibilities may include:

    • Creating functional requirements as an input to application design
    • Working with the client to understand and document their existing processes as well as document their future, improved and standardized processes that will be enabled by the SaaS solution

    • Performing configuration and administration of SaaS solution, based on application designs

    • Developing and testing detailed functional designs for business solution components and prototypes
    • Planning and executing data conversion activities (e.g., test data)
    • Creating training materials, supporting training delivery and providing end-user support

    Basic Qualifications:

        * Bachelors Degree
        * 6+ months of Salesforce.com systems integration and/or implementation experience
        * 1+ years of application requirements gathering and design, including process mapping and gap analysis

    Preferred Skill Requirements:

        * Ability to travel 80%
        * Experience with Microsoft Dynamics or Oracle On Demand

    Primary Locations: USA-IL – Chicago,  USA-NJ - Florham Park, USA-NY -New York, USA-GA - Atlanta, USA-DC - Washington, DC, USA-TX - Dallas, USA-CA - San Francisco, USA-VA - Reston, Minneapolis-MN

    Other Locations: USA-PA - Philadelphia, USA-TX – Houston, USA-MA - Boston, Denver-CO, Detroit-MI


    CRM Salesforce.com Manager

    Location:           Location Negotiable

    Travel:              80% (Monday - Thursday)

    Key responsibilities may include:

    • Project Management

    * Supervising process and functional design activities
    • Creating functional requirements as an input to application design
    • Developing and testing detailed functional designs for business solution components and prototypes
    • Supervising application build, test, and deploy activities
    • Planning and executing data conversion activities (e.g., test data)
    • Driving test planning and execution

    Basic Qualifications:

        * Bachelors Degree
        * 4+ years of Salesforce.com (SFDC) systems integration and/or implementation experience
        * 5+ years of IT Project Management

    Preferred Skill Requirements:

        * Ability to travel 80%
        * Experience with Oracle on Demand or Microsoft Dynamics
        * Basic project management experience
        * Supervisory experience

    Primary Locations: USA-IL – Chicago,  USA-NJ - Florham Park, USA-NY -New York, USA-GA - Atlanta, USA-DC - Washington, DC, USA-TX - Dallas, USA-CA - San Francisco, USA-VA - Reston, Minneapolis-MN

    Other Locations: USA-PA - Philadelphia, USA-TX – Houston, USA-MA - Boston, Denver-CO, Detroit-MI

     

    CRM Salesforce.com Sr. Manager

    Location:           Location Negotiable

    Travel:              80% (Monday - Thursday)

    Key responsibilities may include:

    • Drive overall SaaS project with accountability to Client Stakeholders

    • Create and manage risk, issue and change management for the project

    • Ultimate delivery responsibility - design, build, test, deploy and training activities, on and offshore project team management

    • Provide guidance and expertise to the client to shape their SaaS solutions.  Includes creating deployment, training and governance approaches

    • Identify and pursue business development opportunities - establish scope, estimate, present to client executives, manage contract development and approvals

    Basic Qualifications:

        * Bachelors Degree
        * 8+ years of Salesforce.com (SFDC) systems integration and/or implementation experience
        * 8+ years of IT Project Management

    Preferred Skill Requirements:

        * Ability to travel 80%
        * Experience with Oracle on Demand or Microsoft Dynamics
        * Project management experience
        * Supervisory experience

    Primary Locations: USA-IL – Chicago,  USA-NJ - Florham Park, USA-NY -New York, USA-GA - Atlanta, USA-DC - Washington, DC, USA-TX - Dallas, USA-CA - San Francisco, USA-VA - Reston, Minneapolis-MN

    Other Locations: USA-PA - Philadelphia, USA-TX – Houston, USA-MA - Boston, Denver-CO, Detroit-MI

    ____________________________________