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.
Hi @petite! My understanding is that YYYY-MM-DD is the ONLY Date format for Alteryx. Alteryx expects you to convert whatever fields you wish to be a Date format to that structure (via the DateTime tool for example). Otherwise, you won't be able to perform calculations using Date functions. My recommendation is to use the Date field type (YYYY-MM-DD format) throughout your workflow then at the very end convert the field to a string in your desired UK format with the Formula tool. Probably not the answer you wanted, but I find that once you get used to the Alteryx date format, you'll enjoy the consistency of a single date structure for calculations.
The Date Field Type in Alteryx requires that the format be YYYY-MM-DD. The advantage of this is that you can now do math with the date functions. However, we do also realize that for reporting purposes in the final output of your workflow you may want another date format. This is where the Date/Time tool comes in to play. Many people use this tool to convert their dates from string format (ie. Anything other than YYYY-MM-DD) to the YYYY-MM-DD format. However, a commonly missed function of this tool is that it works the other way as well.
As you can see in this screenshot, you will want to take a Date Field and convert it to a formatted string. In the box below you are declaring what format you want your output to look like (in your case DD/MM/YYYY). The tool outputs a new field called DateTime_Out which will contain your newly formatted string.
This avoids you having to use a Formula tool and breaking apart the date string and pieceing it back together manually.
Hi Paul Yes I have a date field converted to a string "Mon dd".
My query pulls in the last 30 days from 2 sources then its sorted, summed by day, and then and then joined the converted date columns.
If you can see below the sort comes out alphabetical putting DEC firs then NOV last the the dd numbers in proper sort order. I've tried to reconvert it to a date but to no avail... Any help sorting from Nov thru Dec? Thank you for responding
After some egg nog and a few days away I realized I can sort on the actual system date format to make the text date roll in sequential order. I don't need to include the system date in my output either. Thanks for listening :)