Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filtering data using a date field (from SalesForce) = today date

Hello,
I'm a beginner in Talend...
What i want to do is simple, i want to make a filter based on a date field (LastModifiedDate) from SalesForce...
My selection will only contain records which where modified today... 
In tmap i added this filter :
TalendDate.getDate("YYYY-mm-dd")=TalendDate.formatDate("yyyy-MM-dd",row1.LastModifiedDate)
And each time i try i got : "the left side of an assignment must be a variable"...
I do really have a problem with syntax... can you help me ?
My whish, something simple Smiley Happy
Labels (3)
10 Replies
Anonymous
Not applicable
Author

@Navyasri Nekkanti​ , please refer to the salesforce developer documentation, you can try to use the date literal YESTERDAY in the condition field. eg:

"LastModifiedDate=YESTERDAY "

 

Please try and let me know if it works.

 

Regards

Shong