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 !
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"?
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'"
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.