Publication email placeholder get current date.

[former_member419024]

Is it possible to get current month in Publication Email Subject body???

[former_member419024 · Accepted solution]

For Source Document in Publication

-Created Current Year and Previous Month script in derived table to get the value and added extra 2 dimension in business layer, publish the universe and added extra query to the specific report(Just query, dont pull dimension out in report side).

-For Dynamic Recipient list in WEBI Form in Publication

-Created the same Current Year and Previous Month script in derived table to match with Source Document. Publish the universe and added extra query to the specific report(Just query, dont pull dimension out in report side).

-In Data Foundation of Dynamic Recipient list Universe

-Do some neccessary linkage so that when refresh recipient list in WEBI, so that every row in recipient list get the Current Year and Current Month. Example as below:

-At Publication Setting

-In Personalization Mapping, Map Current Year(Source Document) with Current Year(Dynamic Recipient) and do with the same for the Previous Month.

-After All this approach, u will able to add CurrentYear and PreviousYear in Placeholder combobox at email (Choose Value instead of Name, not sure why yet.).

[former_member185603]

It is not possible to display current month, You can only display date and time.

[former_member419024]

Thank You for reply. Need to think another way to do it then.