Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

DateTimeNow(), but I don't want time

Highlighted
7 - Meteor

I don't see a function for DateNow()...do I have to add DateTimeNow and somehow remove the time? Thanks!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Left(DateTimeNow(),10)

.....

Left(DateTimeStart(),10)

2017-12-11

I like DateTimeStart() more.  It is a single date for all records in your workflow.

 

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Alteryx Certified Partner

You could do a Left(DateTimeNow(),10) to get just the date portion.

 

You could also calculate DateTimeNow() into a field with the "Date" data type to get just the date portion.

 

But sadly no DateNow() function that I know of.

 

DateTimeNow.PNG

Highlighted
14 - Magnetar
14 - Magnetar

Hey @mattcoleman! I see @MarqueeCrew and @Garrett were already able to get you what you needed, but I wanted to share the DateTimeToday() function. I tend to use this when I just need the date of today without the time. Just one more way to accomplish the same task! :)

 

datetimetoday.PNG

Labels