I have two fields EVENT_DATE(type DateTime) and EDate(type Date). I am using a workflow to get Date value from EVENT_DATE and store it in EDate. Workflow formula :- DATEVALUE(EVENT_DATE). The workflow fires at record creation time or anytime record is updated.
however i have noticed that the value for EDate in some of the records is not correct.
Example :2015-05-13T22:47:41.000Z is gives 14-05-2015 using the DATEVALUE formula.
This is causing real trouble for our users.
Is there any way to correct this without having to Update all the the data? Any solution in the form of configuration or code is welcome.