Alteryx Designer Desktop Discussions

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

DateTimeNow(), but I don't want time

mattcoleman
8 - Asteroid

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

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus
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 restart. Order shall return.
Please Subscribe to my youTube channel.
Garrett
11 - Bolide

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

Kenda
16 - Nebula
16 - Nebula

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