Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Date Formatting (dd-Mon-YYYY)

Empower49
8 - Asteroid

I am trying to convert 12-FEB-2019 to 2019-02-12. I used the parse tool and a formula tool with no luck. I'm sure this is an easy fix, does anyone have a solution? Thank you!

6 REPLIES 6
Kenda
16 - Nebula
16 - Nebula

Hey @Empower49 

 

If you want to use a Formula tool, create a new field, choose Date as the data type, and use this expression:

datetimeparse([Field1],"%d-%b-%Y")
Empower49
8 - Asteroid

You are my hero. I knew this had to be simple. Thanks so much for being willing to help out a beginner!

Kenda
16 - Nebula
16 - Nebula

@Empower49 

 

Absolutely! That's what this community is all about :) 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@Empower49,

 

A good read for you:  https://community.alteryx.com/t5/Engine-Works-Blog/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/...

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Empower49
8 - Asteroid

Thank you very much for sharing! That will be a fabulous resource.

aries00719
6 - Meteoroid

Sol

Labels