We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.

Alteryx Designer Desktop Discussions

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

Convert V_WString to Mon.-yy Date Format on multiple fields

peyton-brooks
6 - Meteoroid

Hi, as stated in the subject line I need to convert multiple V-WString fields to Date fields and I want them to come out in Mon.-yy format.  The V_WString is currently in Mon.-yy format, but of course it is text vs. an actual date.  I appreciate the help in advance!

11 REPLIES 11
peyton-brooks
6 - Meteoroid

Awesome, thank you!  That worked!  The only con is the [Null] fields created in the date data type format.  I suppose I will let them be while I use the dates to filter an trigger actions in my workflow, and then right before I output I will use the formula you shared to convert back to string and remove nulls with data cleansing.  Thanks! 

MelGibson
10 - Fireball

@peyton-brooks so you didn't need your date in that format after all with a date type field. 

Labels
Top Solution Authors