Forum Discussion

silygose's avatar
silygose
Occasional Contributor
10 years ago

Datasoure reading dates in from Excel in different format than specified in Excel

Useing DataSource to read in an excel file. The excel file has a column that is formatted as a date. The excel date is "1/01/2013" or "m/dd/yyyy'. When SoapUI NG reads this same data source date field it reads it in as yyyy/mm/dd. This woirked fine using SoapUI Pro 5.1.2. This faliure started to happen once we updgraded to SoapUI NG. Is there some date format setting in SoapUI NG that can resolve this issue?

 

Thanks in advance.

1 Reply

Sort By
  • nmrao's avatar
    nmrao
    Champion Level 3
    10 years ago

    May be you can try(if possible) changing the required date format like SimpleDateFormat and provide the required format.