In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Changing my string text to a date format

alvingan43
5 - Atom

Hi!

 

How can i change my date to show the weekday of it 
example,  '1 July 2015' to 'Monday'

currently the text '1 july 2015' is a V_String data type
Thanks!!

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @alvingan43 you are going to need to parse your date into a ISO format YYYY-MM-DD then format it into the date. You can do this in a formula tool using the Datetime parse and datetime format forumlas.

 

 

Datetimeformat(DateTimeParse([Date],"%d %B %Y"),"%A")

 

datetime_16112023.JPG

 

alvingan43
5 - Atom

This helped a lot!! thanks!!

Labels
Top Solution Authors