rpaterick Posted August 3, 2010 Share Posted August 3, 2010 Data comes in as this for an example: Offer Valid 8/6/2010 to 9/19/2010 What I would like to do is capture just the DATES and format them. I kind of have an idea on how to trim but can't figure out how to get Rule 1 below date. Rule 1 would then return: 08/06/2010 If the input data was 12/12/2010, then it would just return as is, no leading 0. Rule 2 would then return: 09/19/2010 Thanks for any insight. Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.