Did They Replace Our Date Calc?
Our Date Calc has been around since the beginning of our MyFusion Helper app, and we have been consistently improving it – with getting order dates, tag applied dates…and a bunch more features.
But here's something you probably didn't know, because it's an undocumented Infusionsoft™ post, you can actually do the basics of what our Date Calc does yourself!
THAT'S AMAZING …AND HERE'S HOW YOU DO IT!
It is a bit of a learning curve, but nothing's impossible, and here's an amazing documentation Martin Cash (an Infusionsoft employee ❤️) has provided for all of you guys:
| merge field | Result (US format) | Result (UK format) |
| ~today.date~ | 2016-03-15 | 2016-03-16 |
| ~today.date|iso~ | 2016-03-15 | 2016-03-16 |
| ~today.date|full~ | Tuesday, March 15, 2016 | Wednesday, 16 March 2016 |
| ~today.date|long~ | March 15, 2016 | 16 March 2016 |
| ~today.date|medium~ | Mar 15, 2016 | 16-Mar-2016 |
| ~today.date|short~ | 3/15/16 | 16/03/16 |
| ~today.date|minus_years(1)~ | 2015-03-15 | 2015-03-16 |
| ~today.date|minus_years(1)|iso~ | 2015-03-15 | 2015-03-16 |
| ~today.date|minus_years(1)|full~ | Sunday, March 15, 2015 | Monday, 16 March 2015 |
| ~today.date|minus_years(1)|long~ | March 15, 2015 | 16 March 2015 |
| ~today.date|minus_years(1)|medium~ | Mar 15, 2015 | 16-Mar-2015 |
| ~today.date|minus_years(1)|short~ | 3/15/15 | 16/03/15 |
| ~today.date|minus_months(1)~ | 2016-02-15 | 2016-02-16 |
| ~today.date|minus_months(1)|iso~ | 2016-02-15 | 2016-02-16 |
| ~today.date|minus_months(1)|full~ | Monday, February 15, 2016 | Tuesday, 16 February 2016 |
| ~today.date|minus_months(1)|long~ | February 15, 2016 | 16 February 2016 |
| ~today.date|minus_months(1)|medium~ | Feb 15, 2016 | 16-Feb-2016 |
| ~today.date|minus_months(1)|short~ | 2/15/16 | 16/02/16 |
| ~today.date|minus_weeks(1)~ | 2016-03-08 | 2016-03-09 |
| ~today.date|minus_weeks(1)|iso~ | 2016-03-08 | 2016-03-09 |
| ~today.date|minus_weeks(1)|full~ | Tuesday, March 8, 2016 | Wednesday, 9 March 2016 |
| ~today.date|minus_weeks(1)|long~ | March 8, 2016 | 09 March 2016 |
| ~today.date|minus_weeks(1)|medium~ | Mar 8, 2016 | 09-Mar-2016 |
| ~today.date|minus_weeks(1)|short~ | 3/8/16 | 09/03/16 |
| ~today.date|minus_days(1)~ | 2016-03-14 | 2016-03-15 |
| ~today.date|minus_days(1)|iso~ | 2016-03-14 | 2016-03-15 |
| ~today.date|minus_days(1)|full~ | Monday, March 14, 2016 | Tuesday, 15 March 2016 |
| ~today.date|minus_days(1)|long~ | March 14, 2016 | 15 March 2016 |
| ~today.date|minus_days(1)|medium~ | Mar 14, 2016 | 15-Mar-2016 |
| ~today.date|minus_days(1)|short~ | 3/14/16 | 15/03/16 |
| ~today.date|plus_years(1)~ | 2017-03-15 | 2017-03-16 |
| ~today.date|plus_years(1)|iso~ | 2017-03-15 | 2017-03-16 |
| ~today.date|plus_years(1)|full~ | Wednesday, March 15, 2017 | Thursday, 16 March 2017 |
| ~today.date|plus_years(1)|long~ | March 15, 2017 | 16 March 2017 |
| ~today.date|plus_years(1)|medium~ | Mar 15, 2017 | 16-Mar-2017 |
| ~today.date|plus_years(1)|short~ | 3/15/17 | 16/03/17 |
| ~today.date|plus_months(1)~ | 2016-04-15 | 2016-04-16 |
| ~today.date|plus_months(1)|iso~ | 2016-04-15 | 2016-04-16 |
| ~today.date|plus_months(1)|full~ | Friday, April 15, 2016 | Saturday, 16 April 2016 |
| ~today.date|plus_months(1)|long~ | April 15, 2016 | 16 April 2016 |
| ~today.date|plus_months(1)|medium~ | Apr 15, 2016 | 16-Apr-2016 |
| ~today.date|plus_months(1)|short~ | 4/15/16 | 16/04/16 |
| ~today.date|plus_weeks(1)~ | 2016-03-22 | 2016-03-23 |
| ~today.date|plus_weeks(1)|iso~ | 2016-03-22 | 2016-03-23 |
| ~today.date|plus_weeks(1)|full~ | Tuesday, March 22, 2016 | Wednesday, 23 March 2016 |
| ~today.date|plus_weeks(1)|long~ | March 22, 2016 | 23 March 2016 |
| ~today.date|plus_weeks(1)|medium~ | Mar 22, 2016 | 23-Mar-2016 |
| ~today.date|plus_weeks(1)|short~ | 3/22/16 | 23/03/16 |
| ~today.date|plus_days(1)~ | 2016-03-16 | 2016-03-17 |
| ~today.date|plus_days(1)|iso~ | 2016-03-16 | 2016-03-17 |
| ~today.date|plus_days(1)|full~ | Wednesday, March 16, 2016 | Thursday, 17 March 2016 |
| ~today.date|plus_days(1)|long~ | March 16, 2016 | 17 March 2016 |
| ~today.date|plus_days(1)|medium~ | Mar 16, 2016 | 17-Mar-2016 |
| ~today.date|plus_days(1)|short~ | 3/16/16 | 17/03/16 |
| ~today.time~ | 11:42:21.583 | 04:11:54.778 |
| ~today.time|iso~ | 11:42:21.583 | 04:11:54.778 |
| ~today.time|full~ | 11:42:21 AM | 04:11:54 |
| ~today.time|long~ | 11:42:21 AM | 04:11:54 |
| ~today.time|medium~ | 11:42:21 AM | 04:11:54 |
| ~today.time|short~ | 11:42 AM | 04:11 |
| ~today.time|minus_hours(1)~ | 10:42:21.583 | 03:11:54.778 |
| ~today.time|minus_hours(1)|iso~ | 10:42:21.583 | 03:11:54.778 |
| ~today.time|minus_hours(1)|full~ | 10:42:21 AM | 03:11:54 |
| ~today.time|minus_hours(1)|long~ | 10:42:21 AM | 03:11:54 |
| ~today.time|minus_hours(1)|medium~ | 10:42:21 AM | 03:11:54 |
| ~today.time|minus_hours(1)|short~ | 10:42 AM | 03:11 |
| ~today.time|minus_minutes(1)~ | 11:41:21.583 | 04:10:54.778 |
| ~today.time|minus_minutes(1)|iso~ | 11:41:21.583 | 04:10:54.778 |
| ~today.time|minus_minutes(1)|full~ | 11:41:21 AM | 04:10:54 |
| ~today.time|minus_minutes(1)|long~ | 11:41:21 AM | 04:10:54 |
| ~today.time|minus_minutes(1)|medium~ | 11:41:21 AM | 04:10:54 |
| ~today.time|minus_minutes(1)|short~ | 11:41 AM | 04:10 |
| ~today.time|minus_seconds(1)~ | 11:42:20.583 | 04:11:53.778 |
| ~today.time|minus_seconds(1)|iso~ | 11:42:20.583 | 04:11:53.778 |
| ~today.time|minus_seconds(1)|full~ | 11:42:20 AM | 04:11:53 |
| ~today.time|minus_seconds(1)|long~ | 11:42:20 AM | 04:11:53 |
| ~today.time|minus_seconds(1)|medium~ | 11:42:20 AM | 04:11:53 |
| ~today.time|minus_seconds(1)|short~ | 11:42 AM | 04:11 |
| ~today.time|plus_hours(1)~ | 12:42:21.583 | 05:11:54.778 |
| ~today.time|plus_hours(1)|iso~ | 12:42:21.583 | 05:11:54.778 |
| ~today.time|plus_hours(1)|full~ | 12:42:21 PM | 05:11:54 |
| ~today.time|plus_hours(1)|long~ | 12:42:21 PM | 05:11:54 |
| ~today.time|plus_hours(1)|medium~ | 12:42:21 PM | 05:11:54 |
| ~today.time|plus_hours(1)|short~ | 12:42 PM | 05:11 |
| ~today.time|plus_minutes(1)~ | 11:43:21.583 | 04:12:54.778 |
| ~today.time|plus_minutes(1)|iso~ | 11:43:21.583 | 04:12:54.778 |
| ~today.time|plus_minutes(1)|full~ | 11:43:21 AM | 04:12:54 |
| ~today.time|plus_minutes(1)|long~ | 11:43:21 AM | 04:12:54 |
| ~today.time|plus_minutes(1)|medium~ | 11:43:21 AM | 04:12:54 |
| ~today.time|plus_minutes(1)|short~ | 11:43 AM | 04:12 |
| ~today.time|plus_seconds(1)~ | 11:42:22.583 | 04:11:55.778 |
| ~today.time|plus_seconds(1)|iso~ | 11:42:22.583 | 04:11:55.778 |
| ~today.time|plus_seconds(1)|full~ | 11:42:22 AM | 04:11:55 |
| ~today.time|plus_seconds(1)|long~ | 11:42:22 AM | 04:11:55 |
| ~today.time|plus_seconds(1)|medium~ | 11:42:22 AM | 04:11:55 |
| ~today.time|plus_seconds(1)|short~ | 11:42 AM | 04:11 |
| ~today.date_and_time~ | 2016-03-15T11:42:21.583+13:00[Pacific/Auckland] | 2016-03-16T04:11:54.778+13:00[Pacific/Auckland] |
| ~today.date_and_time|iso~ | 2016-03-15T11:42:21.583+13:00 | 2016-03-16T04:11:54.778+13:00 |
| ~today.date_and_time|full~ | Tuesday, March 15, 2016 11:42:21 AM NZDT | Wednesday, 16 March 2016 04:11:54 o'clock NZDT |
| ~today.date_and_time|long~ | March 15, 2016 11:42:21 AM NZDT | 16 March 2016 04:11:54 NZDT |
| ~today.date_and_time|medium~ | Mar 15, 2016 11:42:21 AM | 16-Mar-2016 04:11:54 |
| ~today.date_and_time|short~ | 3/15/16 11:42 AM | 16/03/16 04:11 |
| ~today.date_and_time|custom(MM-dd-yyyy h:mm a)~ | 03-15-2016 11:42 AM | 03-16-2016 4:11 AM |
| ~today.date_and_time|custom(yyyy)~ | 2016 | 2016 |
| ~today.date_and_time|custom(yyyy-MM)~ | 2016-03 | 2016-03 |
| ~today.date_and_time|custom(yyyy-MM-dd)~ | 2016-03-15 | 2016-03-16 |
| ~today.date_and_time|custom(MM)~ | 03 | 03 |
This is great because you do not need to save these values to custom fields, and they are “updated” everyday, since it's time and date based. You would use this is in your email copy directly. You can, and should, use these in your emails to create an urgency promo counting down to when it expires – so if you were counting down 3 days for the promo to end, you would use this code first => ~today.date|plus_days(3)|full~
If today is June 19th, it would show as “Thursday, June 22, 2017” inside your emails, then you would add a 1 day timer and then use the same code but plus 2 days so we are still mentioning the same date the next day after the timer => ~today.date|plus_days(2)|full~ , that would still show when the promo ends “Thursday, June 22, 2017”.
Do that one more time if you wanna add one more email (don't forget the 1-day timer and to change the merge field code to plus 1) and then in the final email on Thursday use the today's date merge field => ~today.date|full~
That would be referencing today's date which would be “Thursday, June 22, 2017”. This is great if you just need quick, on the fly date calculations, without using custom fields, this is the way to go. But if you want to have logic in the campaign builder via decision diamond this is a no go. Because there's no way to save the promo date to a custom field… and if you want to use our Route It Helper to redirect them to the promo order form page if their promo hasn't ended and if it has ended (pasted Thursday) send them somewhere else, you wouldn't be able to reference a custom date field…
So that's it for this week's Tuesday Tip! Check out last week's tip on The 80/20 Guide to Using Lead Sources Effectively, I bet you'll get some gold nuggets out of this tips!
