Date conversions

[Kid_in_Cognos]

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.

[hespora]

2 should be formatting as "Date/Time", leave all fields blank, and specify pattern:

Code Select Expand

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:

Code Select Expand

#prompt('P_FromDate','token')#

and put that data item into a singleton. That can then be formatted.

[dougp]

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.

[Kid_in_Cognos]

Hi Hispora,

I am able to do the conversions as required. Thanks for the tip to create data item :)

Thanks.