community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Have a way to easily get date parts out of a date field

Functions such as Year([Date Field]), Month([Date Field]), and Day([Date Field]) would really help with date-based formulas and filter tests.

4 Comments
Alteryx Certified Partner
Alteryx Certified Partner

Until such a time, how about?

 

DateTimeFormat([Date Field],"%Y") >= '2014'

 

------

 

DateTimeFormat([Date Field],"%m") == '10'

 

-----

 

Just a thought....

I built some Date functions as a Formula AddIn to do exactly this.

dateFunctions.jpg

 

Code is on GitHub: https://github.com/jdunkerley/AlteryxFormulaAddOns

 

Would be nice to see functions expanded in the next release.

Alteryx
Alteryx
Status changed to: Under Review

Hi all,

 

Thanks for the idea (and code!). We're looking at re-vamping all of our DateTime functionality across the product, so we'll keep these ideas in mind when those initiatives kick off.

 

Best,

Alex

Alteryx Certified Partner

Good news for anyone reading this post, these functions are now available in Alteryx Designer 11.5:

  • DateTimeYear(dt)
  • DateTimeMonth(dt)
  • DateTimeDay(dt)