Data format

[Malathi1]

Hi All,

I have a report with a date prompt. This prompt value is being displayed in the report page using displayparam().
For this value, I want to change the format of date(I dont want the same format as it appears in the prompt). Tried using Layout Data Format, but the format is not changing.
Any ideas...

Thanks,
Malathi

 

[Nuffsaid]

Hi,

You can try this (Oracle)....

Create a new data item within your query, cast(?date?,date)

Associate your query to the page

Drop your new data item on the page

Format as required



Nuffsaid.