Hi all,
Is it possilbe in the E-Mail icon in the subject always to take the current date?
Please see attached screenshot where I need to have always todays date and the text "Daily files".
Thank you for your support.
Pascal
Solved! Go to Solution.
Hi @Pascal_R , Yes it possible to make a dynamic field and using it as a subject in the Email Tool. Please refer to the screenshot.
1) need to create a formula using formula tool.
2) Change the configuration of the Email Tool as follows check the box Use field in the subject column and select the field that was created above using formula tool.
I hope this resolves your query.
Do you keep the suject empty in the text input? Somehow its not taking the date.
In addition the date format needs to be dd.mm.yyyy.
Please see attache workflow where I have the issue.
Regards,
Pascal
Hi lawrancehere2901
Can you share that in my Alteryx Test flow? I can't see whats in the text input file...
Thank you,
Pascal
Refer this table whenever you want format the Date.
This will help you to choose correct date format.
Format String | Result |
%d-%b-%y | 01-Aug-16 |
%A, %d %B, %Y | Monday, 01 August, 2016 |
%d-%m-%y | 01-08-16 |
%d-%m-%Y | 01-08-2016 |
%d %B, %Y | 01 August, 2016 |
%d/%m/%y | 01/08/16 |
%d/%m/%Y | 01/08/2016 |
%a, %B %d, %Y | Mon, August 01, 2016 |
%A, %B%e, %Y | Monday, August 1, 2016 |
%m-%d-%y | 08-01-16 |
%m-%d-%Y | 08-01-2016 |
%m/%d/%y | 08/01/16 |
%m/%d/%Y | 08/01/2016 |
%b %d | Aug 01 |
%B %d, %Y | August 01, 2016 |
%B, %Y | August, 2016 |
%Y-%m-%d | 2016-08-01 |
%Y%m%d | 20160801 |
|
|
@Pascal_R , No I have not created any column Subject I just entered a default value as in the given screeshot and created a column subject using the formula tool where i specified that formula. The same date format might have worked for that one as well.
@Pascal_R wrote:
Do you keep the suject empty in the text input? Somehow its not taking the date.
In addition the date format needs to be dd.mm.yyyy.
Please see attache workflow where I have the issue.
Regards,
Pascal
Hi Sapna,
I understood your solution to do it via an Email Tool!
But, is it also achievable by the Events Tab (email via an event) ?
P.S :- I want an email to be sent daily after the workflow is run successfully.
This has been really helpful. Thank you!