Undocumented Merge Field list for Date and Time

Max Classic
1

Closing this topic. These fields should still work in emails, but are no longer officially supported. This functionality will be replaced by a much more powerful template scripting language shortly.

These fields are not available in the merge field list in the Infusionsoft UI. You will need to know the syntax and manually type them in. This feature is called the “TodayFilter”. These date/time fields honor your Infusionsoft time zone and locale settings.

General use is as follows:

  • today.date = just the current date
  • today.time = just the current time
  • today.date_and_time = the current date and time

Then, there are functions. any combination of which may be used with the above (functions can be chained together by adding another |). The minus/plus functions will accept any integer input. The custom formatter expects a valid standard date/time format string. For example:

  • today.date|minus_years(1) = subtracts a year from the current date
  • today.date|minus_month(2) = subtracts 2 months from the current date

Then, there are formatters, any combination of which may be used with the above (functions and formatters can be chained together by adding another |). For example:

  • today.date_and_time|full = Friday, March 4, 2016 5:23:32 PM MST
  • today.date_and_time|short = 3/4/16 5:23 PM

Here is a complete list:

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
[DateTimeMergeFields.docx|attachment](upload://sUi7dkDGwYVuyY5AWHvAXJ6aVip.docx) (17.5 KB)
8 Likes
2

Very nice! I can see some really good uses for these! Thanks Marty.

3 Likes
3

@martinc , I see you replied to someone Facebook post with this information, and someone mentioned Liquid Templating. I see that the merge fields here are applying functions to the dates.

The question here is can these functions be used for other types of merge fields, and is there other functions that can be applied? Or is it just date specific at the moment?

1 Like
4

@martinc - these are GREAT!! I do, however, have questions

  • Is this a complete list? If not, can we get one?
  • Are these supported?
  • Are these documented officially anywhere?
  • Can we share this complete list publicly with clients and prospects?
2 Likes
5

Thanks Camille!

This is the most up-to-date list of available time/date merge fields. I asked if there was anything else like this and there isn’t.[quote=“Camille_Shieff, post:4, topic:721”]
Are these supported?
[/quote]

These were handed over to me yesterday by a senior QA engineer. Support hasn’t been officially notified of this functionality. I notified the Training team this morning and they are going to take it from here. These were developed some time ago, but never made it into the UI, so they were never officially documented.[quote=“Camille_Shieff, post:4, topic:721”]
Are these documented officially anywhere?
[/quote]

This will be where they are documented. They will likely be mentioned in a help article or future release note, but it will link to this thread.[quote=“Camille_Shieff, post:4, topic:721”]
Can we share this complete list publicly with clients and prospects?
[/quote]

I would wait until Support has been trained on the functionality…which should happen today. I’ll let you know.

2 Likes
6

They are not available for other types of merge fields. Also, I added a better explanation of the “functions” and “formatters” at the top of the post. They can only be entered manually.

1 Like
7

@martinc - are we free to share these yet? I don’t want to jump the gun, but I’d like to get these out via a blog post.

2 Likes
8

Sorry, yes. Support has been trained on this feature.

3 Likes
9

So, these can only be used on the “today” date? If I have a date stored in a custom field on my contact record it seems like I can not add any function or format to it.

2 Likes
10

I had the same thought yesterday, but I realized that I was making things harder on myself. Here’s my solution (it may not work for you, but it definitely does what I need it to do):

2 Likes
11

Merge field for name of next month?

We have monthly billing on products and send out billing reminders close to the end of every month. For example, “This is your invoice for October…” would be sent on Sept 27th. I spend hours manually changing all the months forward in the email copy every month.

I am wondering if there is some kind of secret merge field code that can automate it such that it populates only the name of the next month. Can the merge field for current month be altered somehow to produce “October” when in the month of September, for example?

1 Like
12

You should be able to do something like this

~today.date_and_time|plus_months(1)|custom(m)~

3 Likes
13

Can we use these formatters when merging other date fields?
I have several custom date fields, and I’d love to use the .date|long formatter when merging those into emails.

3 Likes
14

I’m kinda wondering where this stuff was as I was pulling my hair out with my frequency thingy. :crazy_face:

15

This is extremely helpful. Thank you SO much!

Can you tell me the syntax to display just the day of the week three days from now? For example, on Monday, display “Thursday” (as in “This expires Thursday.”)

Thank you!

16

I don’t think you can, with these anyway, whittle it down to displaying just the day’s name but the math would be:

Although, PlusThis does have a date math and format option that would provide you with just the day.

17

I’m trying to determine how to use these types of fields in a decision.

My client has a renewal date 11/1/19, if today’s date is 11/1/18 (6mths prior to 11/1/19) I’d like to send them to the “Renewal Email sequence” if not I’d like to send them to the “Newsletter” sequence.

Thanks!
-Danny

18

@martinc these merge fields appear to not work any more. Has support for this been discontinued?

19

Hey, @mjfleming. I tested a couple of them and they worked for me. Which one in particular didn’t work?

20

@martinc that’s weird. I’m using this one:

~today.date_and_time|medium~ - Mar 15, 2016 11:42:21 AM

I embedded them in a note template that gets applied from a campaign. It use to work but does not appear to be now. How are you doing itr?