Date in VC

[Former Member]

Hi all,

I have created one BI JDBC sytem to access table from Oracle. I have written one query using SQL Editor. That Query displays the Valid From date and Valid To date. If I test the data service it displays the date correctly wat we have given . But whenever i run that model,it displays Jan 01,2000 instead of all date. What is the problem?

Help me in this regard.

Thanks& Regards,

Hemalatha J

[Former Member]

Probably because the underlying number (formatted to a date-representation) is not the same. Some (Excel) uses 1st. of January, 1900, SAP in general uses 1st of january 1970 as a starting point I believe.

Try to "read" the date as a number and afterwards format it into a date-representation using some of the functions available.

Best regards

Jakob

[Former Member]

Hi Jakob,

Thanks for your reply.

That two fields are Date in Table. How can i 'read' the date as number?

Help me in this regard.

Regards,

Hemalatha J