CreateDate Function

[SeanAdams]

Hi there,

Could we please add a simple date function which allows you to construct a date from the basic inputs (rather than having to go through date-time-parse).

Example:

Function CreateDate(Year as integer; optional month as integer; optional day as integer; optional hour as integer; optional minute as optional; optional second as integer) as DateTime

Examples:

• CreateDate(2017) = 2017-01-01 00:00:00
• CreateDate(2017, 4) = 2017-04-01 00:00:00
• CreateDate(2017,04,05) = 2017-04-05 00:00:00

[SeanAdams]

And while we're at it, could we also create a DatePart function to allow the user to specify the part of the date that they want?

e.g. datepart('2017-01-05','day') = 5

[Joe_Mako]

How about: https://jdunkerley.co.uk/2016/05/15/alteryx-formula-add-ins-v1-1/

[SeanAdams]

That's exactly it Joe - if we can get this implemented in the core toolset, that will be a big help.

With large corporates, there is a natural caution about installing binaries from 3rd parties (even though JDunkerley's work is excellent, it would be tough to get it inside our corporate environment). However @jdunkerley79 has done some incredible work which shows just how rich the function tools can become as we continue to highlight the most valuable additions and areas of focus.

Thanks for highlighting this Joe - it's exactly what's needed in the core Alteryx product.

[jdunkerley79]

Thanks for the mention @Joe_Mako

I will add datepart to the next release (sometime this month). 

@SeanAdams If there are suggestions on how I can make it easier for you to get it approved more than happy to take on board and see what I can do. 

In terms of getting into core product, hopefully  anything Alteryx like sufficiently will just get added (startswith and endswith did :))

James