date problem.

[daN baueR]

I would start using 10 digit date fields (MM/DD/YYYY) Luckily storage space isn't as expensive as it used to be. 

Dan



> On Feb 16, 2015, at 1:18 PM, Richard Kreiss <rkreiss at gccconsulting.net> wrote:
> 
> One of my client's emailed me the other day about a date problem.
> Pfcmark = 20
> 
> Here is the problem, they have member records with birthdays as early as the 1920's.  However, they also h handle credit cards with expiration dates after 2020.  This is creating an interesting problem in insuring that the dates are correct.
> 
> I realize that I can write some date check logic for wither date.  Since the doesn't change, It would be easiest to check the birthdate on import by setting pfcmark as part of the import routine.
> 
> I am just wondering how one of you might handle this type of issue.
> 
> 
> Richard Kreiss
> GCC Consulting
> 
> Office: 410-653-2813
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list