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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I have one requirement in which I have few date columns whose format is '2020-12-31' and data type is STRING but I want to parse them into '31-12-2020' format as DATEdatatype . I am using Multi Field Formula for this but not able to write the correct expression. Can you please help me ?
Contract Date Hiring date
I need to have Output:
Contract Date Hiring Date
Also I have one column called Value which has following data :
Thanks for the solution but the thing is i cannot change the datatype of Value which is DOUBLEto V_WSTRING because for further calculations i need to round the value. The Replace function is applicable to string values.
Can you suggest a solution in which I do not have to change the datatype and get the comma value(1,111)
If you're converting the data type you need to save the new value as a new field.
Just to reiterate, if you have your dates in a non yyyy-mm-dd format and numbers using a comma instead of a fullstop, these values can only be stored as strings. And in the formula tool you need to save as a new field to change the data type. Solution is attached to help.
Thank you for the solution but like I mentioned I have (few) 7 to 8 columns which have dates with the format 2020-12-31 for which I am using Multi Field formula because I have to adjust all 8 columns to format