function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sharmila SahooSharmila Sahoo 

created date on case UI is displaying 5/9/2018 date but in backend created date is showing value 6/9/2018 When I am querying through developer console.

created date on case UI is displaying 5/9/2018 date but in backend created date is showing value 6/9/2018 When I  am querying through developer console. I have one workflow rule to calculate Target date depending on Created Date. Since in backend created date is 6/9/2018, target value is getting calculated incorrectly. Dates are working correctly if created before 6 pm but we are facing discrepency in created date if cases are created after 6 pm. Created Date is coming as next days date.

Example of Case after 6 PM.
User-added image
select createdDate from Case where id='5001h000002br24'
2018-09-06T04:04:08.000+0000

Workflow rule to calculate Target_Date depends on Created Date. So, It is also populating incorrect value.
User-added image

Case created before 6 PM.
User-added image
select createdDate from Case where id='5001h000002br6G'
2018-09-06T07:30:11.000+0000

Any help will be appreciated since many users are getting affected due to it.Target date depends on created date . How to solve this issue.
NagendraNagendra (Salesforce Developers) 
Hi Sharmila,

It was just that while displaying the information in the UI, Salesforce converts the date value to the timezone in which the user profile is configured.

So if the user profile is set to some GMT value, Salesforce automatically adjusts the time that is displayed in the date time field for that particular timezone.
Reference:-  For e.g:- I have time zone as GMT+01:00 British Summer Time (Europe/London)

When I am querying the record it gives Created date as 2018-09-07T05:39:54.000+0000 while on UI I have 07/09/2018 06:39.

Hope it helps you.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra
Raj VakatiRaj Vakati
You can Query link this
  
select convertTimezone(createdDate) from Case where id='5001h000002br6G'