Report Builder- Custom Date Stamp in Scheduled Email Subject Line

[kcolston]

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"

[Jennifer_Dungan]

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?

[kcolston]

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.

[Jennifer_Dungan]

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!