This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Functions such as Year([Date Field]), Month([Date Field]), and Day([Date Field]) would really help with date-based formulas and filter tests.
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.
Code is on GitHub: https://github.com/jdunkerley/AlteryxFormulaAddOns
Would be nice to see functions expanded in the next release.
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.
Good news for anyone reading this post, these functions are now available in Alteryx Designer 11.5:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.