pulling record from zoho sheets with deluge, dates are getting malformed
I have an xlsx file i uploaded to drive, and am viewing in sheets. In sheets it shows the correct address format, in the US we us "M/D/YYYY" in this case it's "2/1/2023"
I read in the records suing zoho.sheet.getRecords(resource_ID (of the file in workdrive) ,"sheet1", queryData, "xxx");
QueryDatais defining what row the header is on, and telling it to only pull 5 records for testing.
The problem is in the response, the dates are getting malformed, 1/1/2023 is showing as 44927, 1/31/2023 is showing as 44957, 2/1/2023 is returning as 44958.
So there seems to be some logic to it if you pay attention to the number relative to other dates. How can i get this as a normally formatted date so i can insert it into a Date record in crm? If i run ".toDate()" it does not come back with the correct date. I ran this through 2 seperate "date calculators" and this seems to be days since 12/30/1899.