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

Date Time

Accepted answers

atcodedog05

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

date.yxmd

All comments

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703