I am working with Business Objects Universe and using teradata database.
I m getting the invalid date error while running the report.
There are 2 separate fields date and time. Date is in Date format and time is in char format. I just created 3 different objects which changes the date into char field, time also into char field and concatenated both of them and this field is also character field. i.e. Output is in the format "2009-07-01 07:54" on the report.
Now, I need to do this for IN and OUT times and calculate the difference between two time stamps. When I was trying to change the concatenated field to a date field in the universe, it parses fine. When I use the same object in the report, I m getting invalid date error.
Please help me!!
Thanks in advance!!
Try by adding ":00" at the end of your concatenated field for seconds .... e.g. "2009-07-01 07:54:00" and it should be fine.