Skip to Content
0
Former Member
May 05, 2010 at 08:02 PM

Invalid Dates

77 Views

HI

I'm trying to run a report with all the invalid dates that are in the system.

Dates are stored as Numeric Values and are in this format "20100505" ( May 5th 2010) but there are a whole lot of invalid dates that shouldn't be in the system but somehow and someone finds a way to put them in.

How can I find these invalid dates that do not have the "20100505" format or valid year/month/day???

Examples of invalid dates are

220022222

40002348

23330

458881

Any help is appreciated!

Thanks!