I have a workflow field update which stamps the last modified date to a custom date field.

Right now I am in PST and I see lastModifiedDate as 12-28-2017 4.59PM and in backend 2017-12-29T00:59:37.000+0000.

And the workflow assignment also assigns the value as 12-29-2019.

So does workflow uses the GMT value and not the time that the current user is in?


You're assigning the DateTime value to Date field, without providing any conversion it might use incorrect date.

Use DATEVALUE function in your formula for getting correct date:

| improve this answer | |
  • Does it mean it is using GMT date right now? And will DATEVALUE() will provide date based on the current user timezone. – Saumya Ranjan Satapathy Dec 29 '17 at 18:00
  • That's correct. It is not an issue with workflow but DateTime to Date conversion, also happens in apex by default. – Raul Dec 29 '17 at 20:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.