Change date format in Luminate emails

Options
Nancy Damato 2
Nancy Damato 2 ✭
Fifth Anniversary Photogenic
in Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
Hi - is there a way to format the date in Luminate emails so they don't show up as XX/XX/XXXX?
Tagged:

Comments

  • Brian Mucha
    Brian Mucha ✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    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
    Brian Mucha ✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    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


     

Categories