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.
Dear all, I am trying to change the format of the date from 2019-02-31 to 31/02/2019 i.e. from yyyy-mm-dd to dd/mm/yyyy. I am able to convert it but the datatype i am getting is string. If I try to change the datatype to date, I am getting null as output.
2019-02-31 i used date time tool to convert the date into string, later i used select tool to change datatype to date, but output is null. Please help me with this.
The only format supported by the Alteryx Date data type is yyyy-mm-dd. Any other format must be stored in a string field. If your date is not in this format, using the Select tool to change the field type to date will always result in null.
Why do you need this field to be a date field. Do you need to use it in date calculations? If yes, do your calculations before changing the format. If you really convert it just before the output, then the output file will reflect exactly the format in the string field. If your output is an excel file, when you open it in Excel it will show up as a date value. if your output is a csv, the the string will be in the csv file in dd/mm/yyyy format.