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’?>
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..
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..