In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start 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
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