Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Time Today Format

KmbrlyPC
8 - Asteroid

I am wanting to add today's date in front of the subject heading, but I want it to be in the format of MM/DD/YY, so 2/11/21 for example. Is there a way to modify the formula to do this?

DateTimeToday.PNG

4 REPLIES 4
DannyS
Alteryx Alumni (Retired)

Hi @KmbrlyPC ,

 

Yes there is! Try using the following syntax within your formula tool expression editor:

 

DateTimeFormat(DateTimeToday(),"%m/%d/%y") + ' Cleaning Assigned'

 

See attached for an example workflow as well. Hope this helps!

 

 

Best,

Danny

bpatel
Alteryx Alumni (Retired)

hi @KmbrlyPC ,

 

you can add datetimeformat like this

 

bpatel_0-1613084696465.png

 

hope this helps!

Qiu
21 - Polaris
21 - Polaris

@KmbrlyPC 

I think this works for you.

Capture1.PNG

 

KmbrlyPC
8 - Asteroid

It works, thank you!

Labels