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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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