I need to display the date in header which user selected in date prompt.
I used paramdisplay(date) to display the date in report header.
but the date is displayed as 1 Aug,2009.
i changed the properties to date and set the format as MM/DD/YYYY.
eventhough i am getting the same format only.
please tell me is anyother way to change the dateformat.
it urgent.
thanks.
eas
create a data item in your report query using the prompt parameter
cast(?Date_Parameter? as Date)
now display this data item in your report header and format it
is there anyother to change the date format in paramdisplay itself, bcos my header some one line of message and two dates.
like...
"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX between date range from MM/DD/YYYY to MM/DD/YYYY"
Hi,
Since the value in the ParamDisplayValue(); is in the form of String we can't directly format it to date, instead you can follow the below steps.
1. Add the below statement in the pageheader instead of ParamDisplayValue('orderDate_value1').
timestamp2date (string2timestamp(ParamValue('orderDate_value1')))
where as the 'orderDate_value1' is the one you want to format to date.
2. Select the above created field-> Navigate to 'Properties' tab ->'Data' block->'Data Format'->Select 'Format type' as 'Date'->
'Date separator' (-./ select your choice)->'Date Ordering' (Month,Day,Year-- your choice)-OK.
3. You are done now. Enjoy maadi :)
Regards,
Vishwanatha KN