Hi ,
I would like to thanks to all who helped me in getting my work done for my previous questions.
This time i came up with some new questions ... is there a way to create a calculated column in the SAP BEx query ? I dont have global query edit permissions but i can chage the Local View of the query.
1 )
I have a Original Hire Date and Most Recent Hire Date as two columns in the BEX Query, when i refresh the query it will populate in tow different columns which is usual. But, i would like to combine these two DATE columns (based on some criteria) as one and want to produce as a single DATE columns.
would it be possible... ?
2)
I have two query's in a workbook and the first query will give the employees ID's which i have import in the second query. Is ther any way to import these ID's in to Second query automatically through VBA or some other code ... ?
Thanks in Advance for you kind help.