Date conversion from SAP JSON

My question:

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:

image

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:

image

work well for the date of the day…

thank you in advance for your help.

Hey @adrienbouygues :wave: Welcome to the Postman Community :tada:

Would the following script work?

const moment = require('moment')
const isoDate = moment(1516147200000).format('YYYY-MM-DD')

Hope this helps, but please do let me know if this is not what you are after :slightly_smiling_face:

1 Like

Hello @taehoshino thank you very much!!

The following script is working well for the conversion thank you very much.
My other issue is that my date is retrived this way:

“date”: “/Date(1528588800000)/”

do you have any idea to get directly the unix number: 1528588800000 ?

Thanks again

1 Like

Hey @adrienbouygues :wave:

Glad to hear that it helped!

I understand the response is JSON, correct? Then you can do something like below?

const response = pm.response.json()
const date = response.date // this is to access "date" property of JSON response
const dateTimeStamp = date.split(/\(|\)/g)[1] // this is splitting the "date" string using regular expression
2 Likes