[AccessD] All-In-One Date format Function:

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
>




More information about the AccessD mailing list