In the code that i have pasted, i am getting value from DT_KEY field from the database and storing it in Sheet3.

My requirement is in the sql that i have used:
I need to get the date from Sheet1!C2 field. So let me know how can i change the query to get the input from Sheet2.

I am copy pasting the sql which is in the code,

" SELECT DT_KEY FROM CCDM_MSTR.DT_DIM WHERE CAL_DT=[B]to_date('1/3/2013'[/B]--instead of giving the date i want to pick it from Sheet1's C2 field,'mm/dd/yyyy')"

Please Login or Register  to view this content.