how to convert in a test a date retrived from SAP from Unix Timestamp to iso date.
Details (like screenshots):
Hello to all.
i would like to test if a date retrived from SAP is the same as the one i wanted. i read data with a get (JSON) but the date is retrived in Unix timesamp format. So i started to find a formula to convert it. In excel the formula is (date in unix/86400000)+DATE(1970;1;1) but i would like to do it directly in Postman.
my issue is that SAP retrived me the data like this:
how can i get just 1516147200000 to convert it or is there a function to convert directly the date ??
i tried to work from this with:
work well for the date of the day…
thank you in advance for your help.