We have a table component in which we have a Date field having seeded "Date" validation. we are storing the sysdate in that field using the database function. and one rule is there in which we are using "Select sysdate from dual" as rule SQL to store system date in to that date field.
The problem is sometimes the table component is not opening through Dashboard. It is giving error as "timestamp mut be in format yyyy-mm-dd..." In kcrt_table_entries, somtimes the sysdate is storing as "22-oct-08" and sometimes storing as "2008-10-22 00:00:00".
When it is storing like "2008-10-22 00:00:00" , it is not giving error message,but when it is storing like "22-oct-08", it is giving error message. Why the table component is behaving inconsistently.
Can anyone tell me what is the format to store the date values in the table component fields.