David McAfee
davidmcafee at gmail.com
Wed Oct 21 13:43:38 CDT 2009
Why not set masking at the input/form level? You might be able to do something for these 09/21/09 09-21-09 092109 92109 9212009 But what date are you going to pick for 0909? 09/01/09 or 09/30/09 ? On Wed, Oct 21, 2009 at 11:17 AM, Robert <robert at servicexp.com> wrote: > Hoooooowdy, > Before re-inventing the wheel here, does anyone have or know of a function > that can handle "free form" date formatting. I'm looking for a function that > can parse any input and then format is correctly. > > Example of user inputs: > > 0909 > 09/21/09 > 09-21-09 > 092109 > 92109 > 9212009 > > etc. > > I don't want to use any formatting / Masking settings at the field or table > level. I would like the user to enter it the way they want to (to the most > degree possible)... > > WBR > Robert > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >