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!