In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Date time Format

sgaryali
8 - Asteroid

Hi,

I want to convert Jan.2021 (date time format) into Alteryx standard date time format.

What formula I can use?

Can anyone help

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @sgaryali 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1632397836723.png

 

Hope this helps : )

AngelosPachis
16 - Nebula

Hey @sgaryali ,

 

Supplementing @atcodedog05 post with a very useful page that I suggest you bookmark when working with dates in Alteryx

 

https://help.alteryx.com/20213/designer/datetime-functions

 

It contains a detailed of all date functions and the ways you can manipulate them in Alterx,

 

Hope this helps,

Angelos

Labels
Top Solution Authors