Formatting iMIS Personalization Date Fields

When you add a date personalization from iMIS, you should always consider formatting. Because iMIS stores information with a timestamp, you might end up having this format appear in the personalization when you were really looking for something else! To solve this, Informz provides a SQL view that will give you the ability to personalize a set of standard iMIS date fields in just about any way you would like. Below is a list of the available iMIS dates:

  • NAME.PAID_THRU
  • NAME.JOIN_DATE
  • NAME.MEMBER_STATUS_DATE
  • NAME_FIN.RENEWED_THRU

Additionally, here are the available date formats:

  • US Date: MM/DD/YYYY
  • European Date: DD/MM/YYYY
  • Time Only
  • Month Number
  • Month Name
  • Month Name Abbreviated
  • Day of Week Number
  • Day of Week Name
  • Day of Week Name Abbreviated
  • 4 Digit Year Number
  • 2 Digit Year Number

The personalization itself might look something like this:

%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_US%%

NOTE:  This should be in all capital letters.

How to Add a Date Personalization

First, create a view in iMIS from the Informz-provided SQL, INFORMZ_VIEW_DATE_FORMAT. This is a technical task that requires you to create or modify the SQL, so you'll want someone from your IT team to assist. Informz is happy to work with your technical resources to ensure that everything works as expected!

Type or copy the desired personalization from the table below. These personalizations will not appear in the Personalization dropdown list.

JOIN_DATE

US Date Format
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_US%%
EU Date Format
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_EU%%
Time Only
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_T24%%
Month Number
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_MM%%
Month Name
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_MN%%
Month Name Abbrev.
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_MN_ABR%%
Day of Week Number
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_DD%%
Day of Week Name
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_DOW%%
Day of Week Abbrev.
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_DOW_ABR%%
4-Digit Year
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_YYYY%%
2-Digit Year
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.JOIN_DATE_YY%%

PAID_THRU

US Date Format
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_US%%
EU Date Format
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_EU%%
Time Only
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_T24%%
Month Number
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_MM%%
Month Name
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_MN%%
Month Name Abbrev.
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_MN_ABR%%
Day of Week Number
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_DD%%
Day of Week Name
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_DOW%%
Day of Week Abbrev.
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_DOW_ABR%%
4-Digit Year
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_YYYY%%
2-Digit Year
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_YY%%

RENEWED_THRU

US Date Format
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_US%%
EU Date Format
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_EU%%
Time Only
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_T24%%
Month Number
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_MM%%
Month Name
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_MN%%
Month Name Abbrev.
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_MN_ABR%%
Day of Week Number
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_DD%%
Day of Week Name
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_DOW%%
Day of Week Abbrev.
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_DOW_ABR%%
4-Digit Year
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_YYYY%%
2-Digit Year
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.RENEWED_THRU_YY%%

MEMBER_STATUS_DATE

US Date Format
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_US%%
EU Date Format
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_EU%%
Time Only
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_T24%%
Month Number
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_MM%%
Month Name
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_MN%%
Month Name Abbrev.
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_MN_ABR%%
Day of Week Number
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_DD%%
Day of Week Name
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_DOW%%
Day of Week Abbrev.
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_DOW_ABR%%
4-Digit Year
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_YYYY%%
2-Digit Year
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.MEMBER_STATUS_DATE_YY%%

Examples

If you wish to use a different format, you can combine the date pieces shown above in any way desired. 

Example for Paid Thru: Tuesday, September 30, 2014

Would be achieved using something like this in your mailing:

%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_DOW%%,
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_MN%%,
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_DD%%,
%%IMIS||UD||INFORMZ_VIEW_DATE_FORMAT.PAID_THRU_YYYY%%

Save the Date

With this combination of date formats available, the possible date combinations are rather limitless! If you need any assistance, never forget that you can always reach out to your Advisor.