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

 For the 0909, I would insert the last day of the month for the day.. Would
be used for CC Expiry format...

I was trying to avoid using any masking... I want to grab the data in the
before update event and fix it up or return error.

WBR
Robert




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Wednesday, October 21, 2009 2:44 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] All-In-One Date format Function:

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
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com