Why does an exported review date appear as a number?
Why does an exported review date appear as a number?
In the review export, the Date_review field is provided as a Unix timestamp in seconds. This is why you may see a value such as 1551856307 instead of a formatted date.
To convert it in a spreadsheet, if the value is in A2, use this formula and then apply a date and time format to the cell:
=A2/86400+DATE(1970,1,1)
Function names and argument separators may vary with the spreadsheet language and regional settings.
The displayed time may vary according to the time zone used by the conversion tool. If the field is empty, is not numeric, or the resulting date does not match the review, open a ticket and include an anonymized example row and the file or tool used for the conversion.