ContributionsMost RecentMost LikesSolutionsRe: Parsing a date in groovy. Hi ilovechiku ilovechiku wrote: Not sure why the behavior is so strange in Parsing.. I have code like this //capturing date from response before date parse def bday =jsonResponse.Demographics.BirthDate log.info "Response date Before Date Parse "+bday //Parsing the date from response above def newDate= Date.parse("yyyy-MM-dd'T'HH:mm:ss", bday).format('MM/dd/YYYY') log.info "Response Date"+newDate Output : Response date Before Date Parse 1971-12-28T00:00:00 Response Date12/28/1972 ---??? WHY IS THIS DATE ADDING A EXTRA year? You are getting the above output because you are using the wrong date format. MM/dd/yyyy is right way to use. Replace last line with below def newDate= Date.parse("yyyy-MM-dd'T'HH:mm:ss", bday).format('MM/dd/yyyy') Re: Read data from excel sheet(xlsx) in groovy script - SoapUI Open Source not Pro Hi HimanshuTayal , Thanks for sharing. I see you made use of xls file. I'm specifically looking for reading xlsx file. I have xlsx and not xls. Please share your thoughts if you have any idea or documnet on this. Help would be greatly appreciated! Read data from excel sheet(xlsx) in groovy script - SoapUI Open Source not Pro I'm using SoapUI open source tool. Is there any document or simple sample groovy script to read the data from excel sheet(xlsx only) to do data driven testing? Also, looking for script that will help me to loop the test cases with different set of inputs from xlsx. Please help!