Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Formatting from "Text and Date" Value

quims
8 - Asteroid

Hi Alteryx Community,

 

Would like to seek your assistance on how to convert into date format as dd-Mon-yyyy from both text and date value. I'm using "Date Time" under Parse but i still got an error.

 

Attached is my sample workflow.

 

Both date have different format, date and text.

 

Capture.JPG

 

Capture2.JPG

 

4 REPLIES 4
huynv96
9 - Comet

You can use BB Date tool here: https://community.alteryx.com/t5/Engine-Works-Blog/Introducing-BB-Date-Date-Parsing-for-the-Rest-of-...

Or using regex function to filter format date and parse them separately.

This workflow has two way above.

DiegoParker
10 - Fireball

Hi @quims 

 

Please find my approach attached. The way I used is just using the datetimeparse function in the formula tool. The two calculations are:

 

1) DateTimeParse([Receipt Date],"%m-%d-%y")

2) if IsNull([DateParse]) then DateTimeParse([Receipt Date],"%y-%m-%d") else [DateParse] endif

 

One for eac date format.

 

DiegoParker_0-1583405965020.png

Hope this helps If does, can I ask you to mark it as a solution? this will help other users to find it and will allow us to close the thread. Many thanks!


Best,
Diego

 

 

quims
8 - Asteroid

Thank you, @huynv96

 

Will keep this as a note for my future reference.

quims
8 - Asteroid

Thank you, @DiegoParker 

 

This is very helpful. I was able to insert it into my workflow and running ok.

 

 

Labels