You need to sign in to do that
Don't have an account?
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
So it will take your filter using the running users time zone settings, convert those parameters to UTC then execute the query.
All Answers
So it will take your filter using the running users time zone settings, convert those parameters to UTC then execute the query.
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..
Hi Enth. You r right.. Thanku very much for your answer..I was confused because of day light saving.. Now its working fine.