Free Trial

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
5 - Atom

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
5 - Atom

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