Agentshevy Posted April 27, 2015 Posted April 27, 2015 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?
comment Posted April 27, 2015 Posted April 27, 2015 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. 1
Recommended Posts
This topic is 3765 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 accountSign in
Already have an account? Sign in here.
Sign In Now