Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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