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

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