You need to sign in to do that
Don't have an account?
Pavlo 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)
)
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)
)