Format mask Issue with Date Parameter in Reports
I have a PO date from and PO Date to parameters in my report.the validation is FND_STANDARD_DATE.
I have a condition in my report which is
AND trunc(h.creation_date,'MON-DD-RR HH24:MI:SS') between nvl(:po_date_from ,trunc(h.creation_date,'MON-DD-RR HH24:MI:SS')) and nvl(:po_date_to,trunc(h.creation_date,'MON-DD-RR HH24:MI:SS'))
Iam picking Creation_date from po_headers_all h.my report builder parameters has date datatype and format mask as MON-DD-RR HH24:MI:SS.
The report is erroring out with the following message.
Kindly Advise