• sathya_sam3
  • NEWBIE
  • 10 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 1
    Likes Given
  • 4
    Questions
  • 3
    Replies

Hi

In my organization  Users are Using Different Time Zones example( US-07:00, Uk +04:00).  I know whenever a record is saved in Salesforce it will be saved in UTC timing. And when I run a Lead standard report it converts the UtC timings to the Corresponding owner Timing and giving the Report.. But Am trying to write a Custom Report Between certain dates. Fore example I used as

"CreatedDate >=2013-04-01T00:00:00z and CreatedDate <=2013-04-30T23:59:59z"  It gives the report as per UTC timing and it is not converting as per Lead owners time zone. So am getting the difference in  standard and Custom Reports.

Can anyone help me out.

 

ThankYou

Hi I have a custom setting(CS) field where am saving a SOQL Query. I am passing this query thru the CS field to a global SOBJECT. Now I want to access the field in the sObject which was predefined in the Query. 

 

Query saved in CustomSetting: "login_cred " field "Soqlogin" = "SELECT Id,Registration_Approved__c,SiteProfile__c,SiteProfile__r.Name__c,SiteProfile__r.Default_Home_Page__r.Name__c FROM Contact WHERE UserName__c = username.toLowerCase() AND Password__C = :password "

 

global static SObject currentContact;

List<login_cred__c> logcredlist =[SELECT soqlogin__c FROM login_cred__c LIMIT 1];
string logcred = logcredlist[0].soqlogin__c;

currentContact = Database.query(logcred);

String profileName = currentContact.SiteProfile__r.Name__c;

 

 

Here am getting an error something like :"Save error: Field expression not allowed for generic SObject " 

 

Thanks in advance.

Sathya.S