Jump to content
Server Maintenance This Week. ×

This topic is 3287 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have really tried to figure out this calculation by subtracting the birthday from the current date, I guess that didn't work. I just need to have a countdown to a contacts birthday.

Please how do I go about this?

Link to comment
Share on other sites

How about =

Let ( [
today = Get ( CurrentDate ) ;
birthday =  Date ( Month ( Birthdate ) ; Day ( Birthdate) ; Year ( today ) ) ;
upcomingBirthday = Date ( Month ( Birthdate ) ; Day ( Birthdate) ; Year ( today ) + ( today ≥ birthday ) ) 
] ; 
upcomingBirthday - today
) 

Result is Number and the calculation must be unstored.

  • Like 1
Link to comment
Share on other sites

This topic is 3287 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.