SQL Query Output

ismailr
Posts: 1
Joined: Mon Aug 15, 2016 4:09 pm

SQL Query Output

Postby ismailr » Mon Aug 15, 2016 4:17 pm

Hi,
I design a simple query to extract data from Oracle Database. This query is giving me the correct output through TOAD.
The query is;
select A.JE_HEADER_ID, B.EFFECTIVE_DATE
from gl.gl_je_headers a, gl.gl_je_lines b
where a.je_header_id=b.je_header_id
and b.effective_date>='01-AUG-2016'


I used the same query in PowerPivot data Manage through get data from other sources.
Kindly help me to get the date format to get the correct output through powerpivot.

Thanking You.
Ismail

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest