Adding Date Today

[KamenRider]

Hi,

Can someone help me how I can add the date today under "Subject: Sales Report as of" which under Field1.

 

See attached file.

Thanks,

Kamen

[rzdodson]

If the subject is dynamically created through a formula, for example, you can always include the DateTimeToday formula within the text string that supplies your subject line in your email.

[KamenRider]

Hi @rzdodson 

Thanks for the response however my problem also lies on the sample I have provided which is set in column. How can I insert that date in that column?

Thanks,

Kamen

[rzdodson]

We can update that formula tool to find that specific text and do the replacement you need through concatenating the value in Field 1 with the DateTimeToday grouping. 

[KamenRider]

Hi @rzdodson 

Hi trying to use your formula in some other cases however, it seems not working. I am not sure what went wrong. Below is the input file:

 

Here's the formula you have suggested. You may datetimetoday() for the date.

 

Output of using the formula comes out like this

The correct result should look like this:

 

Please advise as to where I got wrong.

Thanks,

Kamen

 

[rzdodson]

I suspect it is an issue with how your DATE field is formatted prior to coming in to that Formula tool. Typically, when you concatenate field elements in Alteryx, they need to be of the same data type. If you are concatenating a date element to a string field, the date element needs to be a string as well.