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'"
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend