Openurl - problem with date format in url needing to be different to default application date format

Openurl - problem with date format in url needing to be different to default application date format

Hi,
I am embedding date ranges that come from  form entry data fields (date format) to be used in an OPENURL command to select records for a view based on the record date being between the specified range of the dates passed via the OPENURL command.

I couldn't get any recofrds selected so I tinkered with the URL and changed the date in the actual URL in the browser (as input from the form in the URL) from dd-mm-yy to dd-mmm-yy and to my surprise, it worked.

And after much changing of date format via the application settigs, I have proven beyond any doubt that the date comparison will only work when the date format in the OPENURL is different to the application default..

Specifcally, when the application date format is set to dd-mm-yy  ie 10-12-09  the date enquiry will only work if the url date is in the format dd-mmm-yy  ie 10-dec-09.

Then, when I change the application date to be dd-mmm-yy, the URL selection only works if the date in the url is in the format dd-mm-yy ie 10-12-09

It is really strange the way it only works when the date in the uRl is different to the applcation default date