Changing my string text to a date format

[alvingan43]

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!!

[JosephSerpis · Accepted solution]

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")

[alvingan43]

This helped a lot!! thanks!!