Hi, Please help me with the below transformation in a flow:
Current state: 26.10.2020, type V_String
Desired date: 26/10/2020, type Date; so that I would a pply a filter and select the dates up to a fixed one.
Thanks!
Andreea
Solved! Go to Solution.
Hi @aviziteu,
Alteryx uses the ISO format yyyy-mm-dd HH:MM:SS to represent dates and times. Here's a link to more info about DateTime Functions and converting your dates into your desired format once you have Filtered to the desired range - https://help.alteryx.com/current/designer/datetime-functions
Hi @Emil_Kos
Thanks for replying,
This is a sample:
AS IS: | Desired state: | ||
Opened Date | Date/Time Closed | any format that could be used in filtering the dates, recognized as Date/Date Time | |
7.8.2019 | 7.8.2019 10:57 | ||
25.7.2019 | |||
17.1.2019 | 17.1.2019 11:51 |
I am thinking to try with this formula:
DateTimeParse("2016/28-03","%Y/%d-%m")
I am looking forward to hearing your feedback.
Thanks,
Andreea
Thanks @Aaron_Harter , I am lost with the dates, the article is helpful.
Hi @aviziteu,
I am not expert with regex so I use date time parse tool.
Please mark as an answer if this was helpful for you!
Hi @aviziteu
Here is a workflow to parse the given dates
DateTimeParse([Opened Date],"%d.%m.%y") // only date
DateTimeParse([Date/Time Closed],"%d.%m.%y %H:%M") // date & time
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
This is awesome stuff, thanks, worked for me 😉
Thank you, @atcodedog05 !