Change date format in Luminate emails

Nancy Damato

Hi - is there a way to format the date in Luminate emails so they don't show up as XX/XX/XXXX?

Brian Mucha

One option would be to use brute force and the S130 Polish Notation tag. Here's a great breakdown on this complicated tag from Chris.

https://community.blackbaud.com/forums/viewtopic/1/961?post_id=961#p961


I wonder if there is another tag that would do this easier, but blackbaud.com is down along with all the Tag docs. There are other tags (T-Tags, C-Tags, etc) besides S-Tags that might cover this. Can't recall, but I would look there too.


BPM

Brian Mucha

You can format the current date [[S9]]. Presumably your date comes from an S-Tag you can't format.


I'm sure there is a more elegant solution, but this works and supports one or two digits.


[[E130: "1/30/1999" 0 [[S130:"1/30/1999" "/" indexof]] substring]]

[[E130: "1/30/1999" [[S130:"1/30/1999" "/" indexof]] 1 + [[S130:"1/30/1999" "/" lastindexof]] substring]]

[[E130: "1/30/1999" [[S130:"1/30/1999" "/" lastindexof]] 1 + [[S130:"1/30/1999" length]] substring]]


[[E130: "12/1/1999" [[S130:"12/1/1999" "/" lastindexof]] 1 + [[S130:"12/1/1999" length]] substring]]

[[E130: "12/1/1999" 0 [[S130:"12/1/1999" "/" indexof]] substring]]

[[E130: "12/1/1999" [[S130:"12/1/1999" "/" indexof]] 1 + [[S130:"12/1/1999" "/" lastindexof]] substring]]



Here's how it would look using an S-Tag for the date. I'll use S9 here (though again - you could just format that one with the S9 tag itself.)


[[E130: "[[S9:Survey]]" 0 [[E130:"[[S9:Survey]]" "/" indexof]] substring]]

[[E130: "[[S9:Survey]]" [[E130:"[[S9:Survey]]" "/" indexof]] 1 + [[E130:"[[S9:Survey]]" "/" lastindexof]] substring]]

[[E130: "[[S9:Survey]]" [[E130:"[[S9:Survey]]" "/" lastindexof]] 1 + [[E130:"[[S9:Survey]]" length]] substring]]


Change the order at will:


This is today as an ISO date: [[E130: "[[S9:Survey]]" [[E130:"[[S9:Survey]]" "/" lastindexof]] 1 + [[E130:"[[S9:Survey]]" length]] substring]]-[[E130: "[[S9:Survey]]" 0 [[E130:"[[S9:Survey]]" "/" indexof]] substring]]-[[E130: "[[S9:Survey]]" [[E130:"[[S9:Survey]]" "/" indexof]] 1 + [[E130:"[[S9:Survey]]" "/" lastindexof]] substring]].


BPM