Forum Discussion

rameshsoapui's avatar
rameshsoapui
Contributor
11 years ago

[Registered] date format while send request from soapui

Hi

I have date format in Excel is : 1/1/2013 in datasource step, and api requires that format...

but soapui is sending request with like 'Jan 1, 2013' assuming it is reading as 01/01/3000

so how to send date as MM/DD/YYYY format to soapui ?

5 Replies

  • GPillai's avatar
    GPillai
    Occasional Contributor
    11 years ago
    create a data gen - have the variable created as script and write a code as :return new java.text.SimpleDateFormat("yyyy-MM-dd").format(new Date())


    use this variable as paramter . Hope this helps
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    11 years ago
    Hi,

    You can do what GPillai said using a data gen as a workaround, but for it to work from an excel file you need to open the excel file and right click -> "Format Cells" and choose Date. Then select the format you want the Date to be displayed in.


    Regards,
    Marcus
    SmartBear Support
  • rameshsoapui's avatar
    rameshsoapui
    Contributor
    11 years ago
    I did format cells the format what I was looking, problem seems in 5.1.2, where as in 5.0.0 version same test working fine.
    So issue is still there with version 5.1.2

    I can look into alternatives as pillai mentioned.
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    11 years ago
    Hi,

    I have opened internal defect SOAP-3110 for this as this is a regression bug.


    Regards,
    Marcus
    SmartBear Support