Hi,
1. I m using a date prompt which I am using in report page as ParamDisplayValue('P_FromDate') . And I am getting the output as
Jan 27, 2016. But my output should be as 27/05/2016.
2. My date column in the list is displaying as Apr 1, 2016 12:00:00 AM . But the output should be as the format like 15/02/2016 09:05:13.
My DB is oracle. I tried by changing date format in the properties. But not succeeded.
Can you tell me how can I achieve it.
Thanks.
2 should be formatting as "Date/Time", leave all fields blank, and specify pattern:
dd/MM/yyyy hh:mm:ss
as for 1 - is there a specifc reason you are doing a layout calculation? Instead I would suggest, create a data item in your query:
#prompt('P_FromDate','token')#
and put that data item into a singleton. That can then be formatted.
I haven't worked with date formats that way, but I expect they would adhere to the accepted format in your locale.
I don't know what to say about the values changing from the prompt page to the report. I haven't seen that one before.
Hi Hispora,
I am able to do the conversions as required. Thanks for the tip to create data item :)
Thanks.