From the Mysql table, we are getting the date as “2021-06-07” but when the same date is updated in the Freshsales date field, then the date updated will be “2021-06-06”(i.e. one day date will be updated in the field).
On top of my mind I think the reason could be because of
the timezone difference of the servers? Also how are you updating the date you got from the db in fresservice?
The only valid explanation I could come up with is the timezone difference is there any way you could use libraries such as moment-timezone to transform the time to the required timezone?
Could you please check if any of the updates you pushed recently caused this or check with the freshsales support if your account is in the same region/timezone? this could happen if there is difference in time zone, also could you check if the method/function to convert the timezone is working by hardcoding the values and validating it for expected result