Converting Dates from text! 2

[Julesatwork]

Hello

I am completely new to Business Objects and trying to learn by creating Universes & reports to emmulate an Access 2000 reporting tool which extracts data from an oracle database.

My problem is that the dates stored in Oracle are text i.e. 2001.09.28(weird I know). In Access, I have created a function to convert this text into a date. What can I do to achieve this in Business Ojects?

Any advice would be truly appreciated.

Thanks

 

[jimbopalmer]

Select to_date( '2001.09.28', 'yyyy.mm.dd') from dual;

Is the SQL to do so.

ToDate( '2001.09.28', 'yyyy.mm.dd') is the Business Objects function I tried to remain child-like, all I acheived was childish.

 

[chadlmc]

The functions are specific to the database you are using. If you are using Oracle then you use the Oracle function to convert the date. Try doing this at the database level to ensure maximum response time on the objects in the reports.

 

[Julesatwork]

Thanks for your advice. Do you by any chance know the 'Oracle' function to do this.

Thanks

 

[ATP]

select to_date('2001.09.28','yyyy.mm.dd')
from dual;