Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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