Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Stefano81
Contributor
Contributor

Insert a record on Salesforce, issue with DateTime format

Hello

I have to insert a new record into Sfdc Object, the field EndDate__c datetime is not populated.

In my TMap I have input

Column - EndDate ; Type - Date ; Date Pattern - "yyyy-MM-dd'T'HH:mm:ss'.000Z'"

then in my TMap the output vs Salesforce

Column - EndDate__c; Type - Date ; Date Pattern - "yyyy-MM-dd'T'HH:mm:ss'.000Z'"

the field is always empty, I tried in a different way without success

I added a t_log and the input it seems fine 

|EndDate__c |
|2025-03-28T00:00:00.000Z|

Stefano81_1-1740393455338.png

 

best regards,

Stefano

 

Labels (1)
1 Reply
quentin-vigne
Partner - Creator II
Partner - Creator II

Hi @Stefano81 

Maybe try to debug it by inserting a forced value like instead of out.yourcolumn in your tMap use : 

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss'.000Z'", "2025-02-24T00:00:00.000Z")

Did you check that EndDate__c in Salesforce is a DateTime field, not just a Date field ?

 

If this doesn't solve your issue can you share other screenshots of your Job and your tMap ?