Date being passed differently then format

One Star

Date being passed differently then format

I am reading in a file and setting a date field to Date with a format of MM/dd/yyyy and then using the tMap component I am mapping to my schema as a Date with the format yyyy-MM-dd.  I am then passing this transformed data through tLog and into a tRestClient component.  When the tRestClient component goes to POST the data it is changing the format and causing an error.  Why is Talend changing the data on POST and how do I keep and enforce the yyyy-MM-dd format?
Here is the tLog and tRestClient outputs.
connecting to socket on port 4058
connected
AG1177004|DEA|MedAssests|Georgia Baptist Medical Center|300 Blvd NE||Atlanta|GA|30311|Clinic|1997-09-05|||Clinic
: org.apache.cxf.interceptor.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 1
Address:
Http-Method: POST
Content-Type: application/x-www-form-urlencoded
Headers: {Content-Type=, Accept=, =[]}
Payload: gid=AG1177004&gid_type=EA&gpo=MedAssests&name=Georgia+Baptist+Medical+Center&address1=300+Blvd+NE&address2=+&city=Atlanta&state=GA&zip=30311&gpo_cot=Clinic&cis_cot=+&start_dt=Fri+Sep+05+00%3A00%3A00+EDT+1997&end_dt=1900-01-01
--------------------------------------
: org.apache.cxf.interceptor.LoggingInInterceptor - Inbound Message
----------------------------
ID: 1
Response-Code: 400
Encoding: ISO-8859-1
Content-Type: application/json
Headers: {connection=, Content-Length=, content-type=, Date=, Server=}
Payload: {
    "message": {
        "start_dt": "time data 'Fri Sep 05 00:00:00 EDT 1997' does not match format '%Y-%m-%d'"
    }
}
--------------------------------------
Moderator

Re: Date being passed differently then format

Hi briggleman,
Could you please show us your current job design screenshots?
On which official version did you get that ?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now