Forum Discussion

SK07's avatar
SK07
Contributor
7 years ago

Groovy: compare the date format

I want to compare the date from json 1 & json 2 and display if its match or not in this array. Json1 : {"prods": [{"Item":"11","date": "2018-08-08"} Json2: {"prods": [{"Item":"12","date": 15337008...
Lucian's avatar
Lucian
Community Hero

This is the code that allows you to compare the dates:

 

import java.text.SimpleDateFormat

// Get timestamp
def timestamp = 1533700800000
// Set a date using the timestamp
def date = new Date( timestamp )
// Create a date format as desired
SimpleDateFormat dateFormat = new SimpleDateFormat( "yyyy-MM-dd" )

// Get the other date
secondDate = "2018-08-08"

assert dateFormat.format( date ).equals(secondDate)

Let me know if you also need help with the JSON extraction. I am a little busy now so I can't promise anything though.

SK07's avatar
SK07
Contributor
7 years ago

Lucian, I wanted to read the date(milliseconds) from each array of Json1(convert this date to yyyy-mm-dd)

and compare it with Json2 date (yyyy-mm-dd) of each array.

  • Lucian's avatar
    Lucian
    Community Hero
    7 years ago
    Ok, I will try to also help you with the Json extraction the next week. I am very busy though...
    • richie's avatar
      richie
      Community Hero
      7 years ago

      Hey SK07

       

       

      I typed out a huge response and then I realised my response wouldn't achieve what you wanted - I've got a script courtesy of groovyguy that compares 2 attribute values from 2 different responses and works really quite nicely - unfortunately I didn't read your post properly - the script won't interpret datetimestamp and date values - so sorry - I've wasted your time on this.

      Only reason Ive even replaced my message with this is cos I don't know how to delete a whole message!

       

      cheers,

       

      rich