Different Date formats for parameter

[pradeepbi25]

Hi

1. I have value prompt(?p_month?) in the prompt page with a Month data item and used prompt in the report query as [Month] = ?p_month?.
2. When we run report directly the value in the prompt evaluates to TO_TIMESTAMP ('2015-02-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS.FF');
3. When we run report as a schedule or viewed in Excel format the same prompt value evaluates to '2015-02-28T00:00:00.000'. Since T is not expected in the value, the query fails when report is viewed in Excel; the report runs successfully when run directly.
4. As of now, we handled this issue by creating another version for excel output, and used to_char([Month],'YYYY-MM-DD') = substr(?p_month?,1,10) in the filter expression.
5. Can anyone suggest how to get only date format for parameter.

Thanks
Pradeep