Page 1 of 1

Date Mask

Posted: Mon Mar 30, 2009 5:45 pm
by kld05
Is there a date format that will handle a string in 1/1/2009 or 01/1/2009 or 1/01/2009 or 01/01/2009 format and return a consitent result of 2009-01-01. Year will always be YYYY but day and month may drop the leading zero (source).

Posted: Mon Mar 30, 2009 6:02 pm
by ray.wurlod
No.

Standardize the format of your string (add leading zeroes to month and day) so that you only need one mask.

Search the forum for techniques.