Hi All,
I am looking for a Macro that pull the data from Remedy and it should promt for start date & end date, I am not sure what are all the details required for this. Please let me know if I miss any of the required parameter.
I have tried pulling the data using MS Query and was able to pull the data. In the table instead of having a standard date I have changed it to [Enter Start Date] as a parameter query and it is working in Query however I am getting an error "Driver] Parameter missing" in excel and my query is lost.
Driver used for this is "DSN=AR System ODBC Data Source;ARServer=remedy03;UID=userid;ARAuthentication=;SERVER=NotTheServer"
The code mentioned below works if the date is constant as mentioned below. I have attached the sample result sheet.
SELECT "ATS:AcxiomTechnicalServices"."Ticket Number", "ATS:AcxiomTechnicalServices"."Arrival Time", "ATS:AcxiomTechnicalServices"."Assigned Time", "ATS:AcxiomTechnicalServices"."Closed Time", "ATS:AcxiomTechnicalServices"."Pending Minutes", "ATS:AcxiomTechnicalServices"."Pending Minutes Business", "ATS:AcxiomTechnicalServices"."Assigned To Group", "ATS:AcxiomTechnicalServices"."Closed By Group"
FROM "ATS:AcxiomTechnicalServices" "ATS:AcxiomTechnicalServices"
WHERE ("ATS:AcxiomTechnicalServices"."Assigned Time">={ts '2011-09-01 00:00:00'} And "ATS:AcxiomTechnicalServices"."Assigned Time"<={ts '2011-09-16 00:00:00'}) AND ("ATS:AcxiomTechnicalServices"."Assigned To Group"='cec_windows')
Thanks in advance for all your help!!
Regadrs,
Humac
Bookmarks