Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Pavlo ShchurPavlo Shchur 

How to count days between CreatedDate of Account and Birthdate of Contact within one year. The code below loses 3 days.

ABS(
IF( NOT( ISBLANK( Birthdate ) ) ,
  IF( DATE( 2000 , MONTH( Birthdate ) , DAY( Birthdate ) ) <= 
      DATE( 2000 , MONTH( TODAY() ) , DAY( TODAY() ) ),

      FLOOR(
        (Birthdate - DATEVALUE(Account.CreatedDate)) -
         FLOOR(
         (Birthdate - DATEVALUE(Account.CreatedDate)) / 365.25
              )
      * 365.25
),

      FLOOR(
        (Birthdate - DATEVALUE(Account.CreatedDate)) -
         FLOOR(
         (Birthdate - DATEVALUE(Account.CreatedDate)) / 365.25
              )
      * 365.25
           )
),
  null)
)