Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

DATETIME PARSE to YYYY-MM-DD

kathbanc
8 - Asteroid
‎11-21-2023 12:20 AM

Hi Alteryx Community! 

 

Input :  8/8/2022 10:17:00 AM

 

Output should be : YYYY-MM-DD

 

Thank you in advance

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
Personne
5 - Atom
‎11-21-2023 12:28 AM

Hi,

 

If you are in "IN-BD" mode with Oracle :

 

to_char("YOUR_COLUMN_DATE", 'yyyy-mm-dd')  

Reply
0 Likes
Qiu
21 - Polaris
21 - Polaris
‎11-21-2023 12:43 AM

@kathbanc 

We can use the DateTImeParse function in the Formula tool

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html##

1121-kathbanc.PNG

1121-kathbanc.yxmd
Reply
kathbanc
8 - Asteroid
‎11-21-2023 12:48 AM

Thank you so much @Qiu 

Reply
register for inspire
inspire session catalog
Labels
Top Solution Authors
View All