Converting a unix timestmap to Datetime using Zoho CRM

Question

I'm writing a custom function in Deluge that will take a unix timestamp and convert it to a date string in Eastern Standard Time.

For testing purposes, I have a unix timestamp of 1671718987466

This is equal to Thu Dec 22 2022 09:23:07 GMT-0500 (Eastern Standard Time)

When I test the script in Zoho's Deluge playground using the .toString() method, it gives me the correct values:

    unix = 1671718987466;
    unixString = unix.toString("dd-MMM-yyyy hh:mm:ss", "America/New_York");
    info "Converted unix to date string: " + unixString;

This is the output for the code above:

---

But when I write the exact same lines of code in Zoho CRM function editor, I get an incorrect value that is 3 hours off:

Does anyone have an explanation and a solution for this?

I tried this solution but sadly it did not work.

Answer 1

Please allow me to apologize first as I am putting this as answer instead of comment as I do not have the required reputation.

Could you check the timezone being used in your organization or user? Is it also Eastern Standard Timezone?

Usually, the function will auto-convert the value based on that.

If that was the case, then it could be that your function is using PST or PDT (depends on the date). And you would need Zoho Support to clarify for that.