This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

Calculate Sending Birthday Card

Topic Labels: Formulas
1766 2
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Les_Fenter
5 - Automation Enthusiast
5 - Automation Enthusiast
See Solution in Thread

‎May 11, 2018 06:57 AM

I need a formula for calculating when to send a birthday card that will return a date 10 days prior to the person’s birthday. So if the person’s birthday is 10-10-2019, I want the formula to calculate 10 days prior, or 09-30-2019, returning a date format. Any ideas on that? TIA

0 Kudos
Reply
2 Replies 2
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter
See Solution in Thread

‎May 11, 2018 10:29 AM

Assuming the persons birthday date is in a field called Birthday, put this formula into your Send Card by: field:

DATEADD(Birthday,-10,'days')
0 Kudos
Reply
Les_Fenter
5 - Automation Enthusiast
5 - Automation Enthusiast
See Solution in Thread

‎May 12, 2018 06:48 AM

Thank you so much for helping out this newbie! Perfect solution!

Reply
Copyright © 2024 Khoros, LLC