Reversing Parameter Date from yyyy-mm-dd

[MikeMV]

I am using CR IX and setup a couple of parameters to request a date. The date format on the parameter screen comes up as yyyy-mm-dd. I would like to have that show up as mm-dd-yyyy. I tried changing the field date options in CR Options and the Windows default short and long date, but that does not work.

Is there a way to accomplish this without changing the parameter to a string and doing the conversion?

Thanks in advance for your response.

Miguel.

 

[bgordonct]

The parameter prompt formats (I think) are coded into CR and cannot be changed.

However, you can get around this by creating a string parameter and letting your users enter the data in your mm-dd-yyyy format (just be sure to use an edit mask so they can't enter letters).

Then in your record selection, you can have a formula that converts the String into a Date for your database using the DateValue() function:


{Employee.Hire Date} = DateValue({?MyStringDateParam})

 

[synapsevampire]

Note also that they can click the calendar icon and choose the date from the calendar control.

The default date format is a pain in the arse, hopefully they'll correct it in a future version.

-k