Replace and change data type

[aviziteu]

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

[Emil_Kos]

Hi @aviziteu,

Can you provide us with data sample? 

[Aaron_Harter]

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 

[aviziteu]

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

[aviziteu]

Thanks @Aaron_Harter , I am lost with the dates, the article is helpful.

[Emil_Kos]

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!

[atcodedog05 · Accepted solution]

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 😀👍

[aviziteu]

This is awesome stuff, thanks, worked for me 😉

Thank you, @atcodedog05 !

[atcodedog05]

Happy to help 🙂 @aviziteu 

Cheers and Happy Analyzing 😀