This content has been marked as final. Show 4 replies
u can use the format mask to_char (ur_column_name)
where to use format mask because there is no option of format mask in the property pellet of list item
within ur select statement while creating the query in ur list code Not in property pallet dear...
Set your date column as a hidden (non-displayed) field. Create your list item with the varchar2 day names. Create the list item as a non-base-table field that accepts the text values of day names. On that field, create a when-validate-item trigger that translates the text into a real date, which it then uses to set the value of the actual base-table item.