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.
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
How do I convert 09222018 to a date? I can't get the string to date function to work because I think I have to have it in yyyy-mm-dd format. I tried different ways and cannot achieve this. I also tried the datetimeparse formula, but keep getting a null value.
Can anyone guide me how to convert the format from 2019-02-26 to a date format like this: ddmmmyy (i.e.,26Feb19)?
I tried to use DateTimeParse "DateTimeParse([Incurred From Date],"%d,%b,%y")", but there's a warning message saying cannot convert "2019-04-22" to a date /time with format "],"%d,%b,%y": Expected separator , ],"%b,%y, got '19-04-22'.
I even tried to use the select tool to change the format to date first, but the result keep showing null.
You just need to make sure the format you're providing is exact (i.e. it also contains the '.' and ':' delimiters, and a space between the date and time parts) and that you're using the correct specifiers (the hour-minute-second letters need to be capitalised). You can check your specifiers here: https://help.alteryx.com/current/designer/datetime-functions
(If you want the time included in the output as well, just change the data type to 'DateTime').
You could also use the DateTime tool if you want a friendlier interface: