Here is my dilemma - I have a SQL data set where a date field is an 8 digit numeric field as yyyymmdd. My report uses a parameter field to select the date based on user input. However users occasionally enter non-numeric characters such as commas or periods. When this occurs the SQL database freezes until the user ends program.

I was hoping to use edit mask but seems that can not work on numeric fields. Ideally this field is presented to the user as a date field however I have no way to edit the SQL database. Suggestions?


Thanks


Edited by siweltj - 23 Aug 2012 at 5:15am

Thank you for the help, however gave that a try and get a "Bad Date Format" error in Record Selection. Below is my record selection formula:

{?Date} =date(mid(totext({Schedules.LDate},0,''),5,2)+'/'+right(totext({Schedules.LDate},0,''),2) + '/' +left(totext({Schedules.LDate},0,''),4)) and
{EventStrings.TripCount} > 0 and
{EventStrings.EvStrName} in {?From Route} to {?To Route}      

Edited by siweltj - 23 Aug 2012 at 5:58am

Below is sample of the data from the field which is a number field. Although there is a zero in the data, this would never be a part of the selection:

Thank you, that works. Downside is that it has significantly increased processing time on the report and CPU usage on server side. 500 page report took nearly 10 minutes and 90%+ of peak CPU.

Tremendous improvement. Well done. Thank you.