Reports: Multiple date formats on paramform?

[Quoted] On a report's parameter form that contains two date fields, what is the best method to enable different users to enter different date formats? Ie: we have customer in the US and UK. I want US users to enter dates in 07/17/2000 format and UK users to enter in 17/07/2000, all in the same report (don't want to develop the same report twice with this one difference).

You can accept various date as CHAR in parameter and take care of validation in the trigger, but how and where would you convert the string back to a date. For instance,

My query:
Select datefield1, datefield2
from
table1
where
datefield1 >= :P_RepStartDate
and datefield2 < :P_RepEndDate

So, when running the report for month of July 2000, after the user enters the char date in the param form, the two date parameters will be in one of two formats: '07/01/2000' & '08/01/2000' OR '01/07/2000' & '01/08/2000'. How would I get this to work?

TIA,
Jason

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 19 2000 - 00:00:00 CEST