We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

difference in dates roql query

Accepted answer
10
Views
7
Comments
edited May 9, 2016 7:07AM in Integrations and APIs 7 comments

Content

I am running two queries and date fields on both queries returning different values. please help  

Query 1 (Shows values correctly as in RightNow)

select Customfields.c.billing_date,    Customfields.c.manufacturing_date,    Customfields.c.date_purchase from Incident     where referencenumber = '160509-000002'

Screenshot

Query 2 (Incorrect date values)

Select Customfields.c.billing_date,status,  Customfields.c.case_origin,        Customfields.c.cust_sat_level,  Customfields.c.entered_by,       CustomFields.co.faultcategory,subject,  Customfields.co.Model,  Customfields.c.manufacturing_date,      Customfields.c.desc,      Customfields.c.cust_remarks,  Customfields.c.remarks, Customfields.c.time_slot,Customfields.c.priority,  Customfields.c.ser_req_type,   Customfields.c.comp_nature,    Customfields.c.descriptioncn,  Customfields.c.incident_trans,  Customfields.c.incident_redo,   Customfields.c.debriefedby,  Customfields.c.prod_ser_num, Customfields.c.comp_man,        Customfields.c.date_purchase,  Customfields.c.old_comp_num, Customfields.c.new_comp_num, Customfields.c.cdcsnumber, Customfields.c.cdcscomplaindate,Customfields.c.cdcscomplainbrief,  Customfields.c.cdcscomplainclosedate, Customfields.c.satisfaction_sms_send.lookupname,  Customfields.c.satisfaction_sms_reply.lookupname,      Customfields.c.customersmsreply,  Customfields.c.satisfaction_tech,  Customfields.c.sat_tech_sms_msg,  Customfields.c.customer_call,   Customfields.c.refrigerator,        Customfields.c.deep_freezer,  Customfields.c.split_ac , Customfields.c.washing_machine,Customfields.c.microwave_oven,  Customfields.c.new_appliance_purchase,CreatedTime,    Customfields.c.case_age, ClosedTime,  customfields.c.cdcscomplainstatus ,customfields.c.billing,customfields.c.case_transferred, customfields.c.redo, customfields.c.sameday_atten , customfields.c.timely_comp, customfields.c.pl_direct, customfields.c.sms_update_check, customfields.c.ishomeattendingormobile, customfields.c.visit_grievance_level , customfields.c.recieption_faults, customfields.c.Loadshedding_Timing, customfields.c.call_before_attend from Incident   where referencenumber = '160509-000002'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!