function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sathya_sam3sathya_sam3 

Time Zone issue

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

Best Answer chosen by Admin (Salesforce Developers) 
EnthEnth
The report will use the time zone of the person running the report to execute. It doesn't know what the time zone of the Lead Owner is (or care).

So it will take your filter using the running users time zone settings, convert those parameters to UTC then execute the query.

All Answers

EnthEnth
The report will use the time zone of the person running the report to execute. It doesn't know what the time zone of the Lead Owner is (or care).

So it will take your filter using the running users time zone settings, convert those parameters to UTC then execute the query.
This was selected as the best answer
sathya_sam3sathya_sam3

Hi Enth

 

ThankU for the Reply. But am still confused.. what am trying to say is for example lets take 2 lead records..one  lead.Owner is on  -07:00 time zone and other  is on +04:00 time zone.. lets say am on -05:00 time zone..

 

1) Owner one  - Owner timeZone  -07:00    leadcreateddate- 1-1-2013: 11:30PM ( Time saved in salesforce UTC 01-02-2013:06:30.000z)

2)Owner two - Owner time Zone +04:00   leadCreated date   1-1-2013: 12:30AM ( Time saved in salesforce UTC  12-31-2012:20:30.000z)

 

when am running the standard report of 1-1-2013 am getting both the records.. but when am trying Custom Report  from CreatedDate >=2013-01-01T00:00:00z and CreatedDate <=2013-01-01T23:59:59z Iam getting the result as 0...

 

When i try CreatedDate >=2013-01-01T00:00:00-07:00 and CreatedDate <=2013-01-01T23:59:59-07:00 Iam getting the Record One. and

 

CreatedDate >=2013-01-01T00:00:00+04:00 and CreatedDate <=2013-01-01T23:59:59+04:00 I am getting the Record Two..

 

sathya_sam3sathya_sam3

Hi Enth. You r right.. Thanku very much for your answer..I was confused  because of day light saving..  Now its working fine.