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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with OData filter on component tMicrosoftCRMInput (using v2016(odata))

Hi, 

I'm trying to use the component tMicrosoftCrmInput v2016 (odata) to import some data from a Dynamics 365 CRM, and it's working fine, but I can't prefilter data by modifiedon date, I already tried many format ... 

 

modifiedon is a Date type and using the following date format : "yyyy-MM-dd'T'HH:mm:ss'Z'"

Useful translation : Supérieur ou égal = Greater or equal 

Thank you in advance for your answer !

 

 

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hello,

Could you please indicate which talend build version you are using? What does your actual result look like? Is it working when use "yyyy-MM-dd HH:mm:ss"?

Best regards

Sabrina

rp2018
Creator
Creator

I'm having the same issue with filtering modifiedon GreateEqual "'2018-08-20T03:56:13Z'" in tMicrosoftCrmInput component.  Does anyone have a solution for this?  

 

NOTE:  CRM is outputting the modifiedon as "yyyy-MM-dd'T'HH:mm:ss'Z'"