Hello everybody,
i have a strange data format for dates, it is looking like this 10-JAN-20 but of cause this dosent work with Alteryx DateTimeDiff(dt1,dt2,u) function.
Would be really nice if someone could help me to transform this into somethink that work.
Thanks a lot
Timo
Solved! Go to Solution.
Hi @Timo97
Here is how you can do it.
Formula:
DateTimeDiff(
DateTimeParse([Date 2],"%d-%b-%y"),
DateTimeParse([Date 1],"%d-%b-%y"),
"days")
Workflow:
Hope this helps : )
To add to @atcodedog05 's great solution, I suggest saving the below page. It's a good reference for the different syntax and specifiers used in date time functions.
Thanks a lot @atcodedog05 and @Luke_C for this massive help.
Now there is another problem that my data language is different then my Alteryx language can i change this just for this function ?
probably not i guess...
Hi @Timo97
Date format is only changing within the formula. Its not changing the actual data itself your actual data will stay the same.
What i mean@atcodedog05 is that my data language is different than english so the function does not recognise the Months...
Hi @Timo97
If i understand correctly if you are saying your month naming convention is different then it wont work. You would need to use find and replace to replace other language month name to English month name.
That is exactly what i mean
Thanks you very much @atcodedog05 🙂
Happy to help : ) @Timo97
If my response helps please don't forget to mark it as solution.
Cheers and have a nice day!