How to control format of date input

[rictorsan]

Can anyone tell me if there is a way to configure Crystal Reports to allow users to input dates in a configurable format. It seems that the only way u can enter a date, e.g., to satisify a parameter, is mm/dd/yyyy.

Many of our users are Europe based and need to enter dates in dd/mm/yyyy.

There does not appear to be any way to configure this.

Thanks,

rictorsan

 

[synapsevampire]

An alternative would be to build a String parameter, and add an edit mask of:

99/99/9999

Now do a cdate against this when using it in your formulas.

If you need to apss this in a record selection formula, you might have to build a formula to convert the date, and refer to the formula in the record selection formula if you want CR to pass the SQL.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com