Skip to main content
kcolston
Dec 4, 2024 6:20 PM UTC
Solved

Report Builder- Custom Date Stamp in Scheduled Email Subject Line

I'm using a custom date/time stamp in the email subject line of an Adobe Report Builder scheduled report.  Is it possible to include text to separate the date & time in my custom time stamp?  To get something like this-  "Report Name_04-Dec-2024 Thru 9AM"

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jennifer_Dungan
Jennifer_DunganAccepted solution
Adobe Champion and Community Advisor
Dec 4, 2024 10:51 PM UTC

Honestly, I went back and forth on if you wanted literal "Thru" or if that was a typo... oops.. I guess I shouldn't have second guessed myself.

 

So it won't accept a value in the middle?

 

Try adding quotes?

_dd-MMM-yyyy "Thru" h AM/PM

 

 

I think the "h" in "Thru" might be trying to pick up the hour? 

 

Note, I just tested this in a Excel Format Cell... but I would hope the same basic logic would apply???

 

 

The underscore also became a space in my preview, but if I add it in quotes too....

"_"dd-MMM-yyyy "Thru" h AM/PM

 

Fingers crossed!

View in thread

3 replies

Jennifer_Dungan
Adobe Champion and Community Advisor
Jennifer_DunganAdobe Champion and Community Advisor
Adobe Champion and Community Advisor
Dec 4, 2024 8:55 PM UTC

Hi,

 

I've not tried this, but I took a quick look.

 

I assume you are using the Advanced Delivery options:

 

 

So, if you click on "..." next to your subject line, it will open this popup:

 

 

These are just suggestions, showing you that "MM" is a 2 digit example of the month (04), and MMM is the three letter short form of the month (Apr), or "MMMM" is the full month (April). 

 

You should be able to type in whatever you want using these as building blocks.. 

 

So change "yyyy-MM-dd" to:

"_dd-MMM-yyyy ddd h AM/PM"

 

 

I built in the initial _, and added ddd which should result in "mon" or "tue" or "wed", etc (I think that is what you meant you wanted added?)

 

Try that and see if it works for you?

Translate
kcolstonAuthor
Dec 4, 2024 10:42 PM UTC

Thanks Jennifer!

 

Was actually trying to get the 'ddd' from your example to read with the word "Thru"

 

So instead of "_dd-MMM-yyyy ddd h AM/PM" where ddd returns a 3-letter day of the week,

"_dd-MMM-yyyy Thru h AM/PM" so the word "Thru" returns where you have ddd

 

In all of the variations I've tried, the date/time stamp won't correctly format text other than the code examples from your screenshot. It also won't let me add more than 1 date/time stamp to the subject line so i can add my own text in between.

Translate
    Jennifer_Dungan
    Adobe Champion and Community Advisor
    Jennifer_DunganAdobe Champion and Community AdvisorAccepted solution
    Adobe Champion and Community Advisor
    Dec 4, 2024 10:51 PM UTC

    Honestly, I went back and forth on if you wanted literal "Thru" or if that was a typo... oops.. I guess I shouldn't have second guessed myself.

     

    So it won't accept a value in the middle?

     

    Try adding quotes?

    _dd-MMM-yyyy "Thru" h AM/PM

     

     

    I think the "h" in "Thru" might be trying to pick up the hour? 

     

    Note, I just tested this in a Excel Format Cell... but I would hope the same basic logic would apply???

     

     

    The underscore also became a space in my preview, but if I add it in quotes too....

    "_"dd-MMM-yyyy "Thru" h AM/PM

     

    Fingers crossed!

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...