It looks like OLE Automation dates that are used on many systems, such as Microsoft Excel . This is an effective floating point value representing days, with a value of 1.0 equal to midnight on January 1, 1900.
You can convert to python date with:
from datetime import timedelta, datetime d = timedelta(days=41433.662413) st = datetime(1899,12,31) date = st + d print(date)
Opens 2013-06-09 15:53:52.483200 . Although this is different from the May 27 date that you talked about, given that you included more than one input, I suspect this is the correct conversion, as it will be a standard that provides dates and times within the same range as your written note. However, not knowing exactly which entry corresponds to this date, it would be difficult to say.
On May 27th, at 6am, the value 41420.25 will be used using this conversion. I would check this βvalueβ to see if the handwritten note matches this format.
source share