Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Table component date field

SOLVED
Go to solution
Highlighted
Shravan Kathuri
Senior Member

Table component date field

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.

Thanks
Shravan kumar.
6 REPLIES
Darshan Bavisi
Occasional Visitor

Re: Table component date field

Hello Shravan,

Can you please send the screenshots of these scenerios and how the dates are entered in the date field?

Can you please also send the serverLog.txt or its content where if its showing any error messages for the same?
Shravan Kathuri
Senior Member

Re: Table component date field

Hi Darshan Bavisi,

Thank you for your response.

I am attaching the screen shot.But iam not able to get the serverlog file.

Thanks,
Shravan.
Surendra Poosar
Frequent Visitor
Solution

Re: Table component date field

Sravan try to populate using the following rule.
select to_char(sysdate, 'yyyy-mm-dd hh:mi:ss') from dual
Kiran Dubbaka
Occasional Advisor

Re: Table component date field

Hi Shravan :-),

Try to populate the Date in the below specified format.

Select To_Char(sysdate,'YYYY-MM-DD HH24:MI:SS') From Dual

Thanks
Kiran
Shravan Kathuri
Senior Member

Re: Table component date field

Hi kiran, :-)

Thank you for your response.It is working fine now.

Thanks
Shravan Kathuri
Shravan Kathuri
Senior Member

Re: Table component date field

Hi surendra,

thank you for your response. It is working fine now.

Thanks,
Shravan Kathuri
//Add this to "OnDomLoad" event