This content has been marked as final. Show 12 replies
Hey to apply the format-date,
you got to have the data in xml as this format:
YYYY-MM-DDThh:mm:ss+HH:MM or YYYY-MM-DD
Try this simple xml and template:
in rtf put this
this wont work <?format-date:P_APPLY_DATE_LOW_N;’YYYY-MM-DD’?>
this works <?format-date:P_APPLY_DATE_LOW;’YYYY-MM-DD’?>
this too works <?format-date:P_APPLY_DATE_AAA;’SHORT’?>
Hi vetsrini ,
Thanks for the feedback.
Is it possible to truncate or substring data retuned from parameters?
Yes , you can do that.
I am looking for date format for different languages in RTf template.
US: 10-Dec-09 German: 10-Dez-09 etc
Any idea how to do that??
Put the following in the FORM FIELD help Text inside the help Key (f1) tab:
One more requirement i have that I dont wnat to use any to_date,to_char or decode function and i want to display date in format 'DD/MM/YYYY'.
My query is: select creation_date from po_requisition_headers_all;
and it's returning date in 'DD-MON-YY' format in XML data.
Now I want to change the date format in other formats like 'DD/MM/YY' or 'DD/MON/YY' etc.. in RTF template only. I don't want any modification in my queru if it's really not required.
Can anybody have idea how to achieve this..
You could use the same example I gave above for this requirement. You would have to slightly modify that.
I am having a similar problem. What is happening I have blanks and Nulls in a date field. The rtf template is putting the word "null" in all blanks. I need to replace the word "null" with blanks. I am new to BI and have no clue as to what steps need to happen. Your expertise would be greatly appreciated. Thank you in advance.
Edited by: Mr B on Sep 28, 2009 11:41 AM
I am selecting my date column as 'fnd_date.date_to_canonical(prh.creation_date) RD' in my report. date in XML output is coming as '2008/10/02 10:25:59'.
and in RTF template- seleted field as date with <?format-date:RD;'DD-MON-YY'?> but date formatting is not working.
Do I am missing anything or giving anything wrong..
Try changing your report to select "to_char(prh.creation_date, 'YYYY-MM-DD') RD"
Try this <?xdoxslt:sysdate('DD-Mon-YYYY hh12:mi:ss’)?>