topic Filtering data using a date field (from SalesForce) = today date in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 10:49:32 GMT

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

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

Anonymous — Thu, 04 Feb 2016 07:39:24 GMT

Hi
Try this expression:

TalendDate.getDate("YYYY-mm-dd").equals(TalendDate.formatDate("yyyy-MM-dd",row1.LastModifiedDate))

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

Anonymous — Thu, 04 Feb 2016 07:49:23 GMT

Yes this seems great... thanks a lot...
Now my problem is : the processe will read all the rows of the source table... and will not let anything goint thrue tmap (date formating problem ??)
Maybe it would be better to put the equivalent in the query condition directly in the tSalesforceInput... but the syntax is one more time different ...
Would you help me again ?
I already do a lot of thing with Talend, it's an incredible soft, love it

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

Anonymous — Thu, 04 Feb 2016 11:17:36 GMT

If i put in query condition :
"SkuUpdDate__c='2016-02-04'" it works perfectly...
what should i put instead of '2016-02-04' to get today's date ? something like get date ect....
Thanks in advance

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

Anonymous — Fri, 05 Feb 2016 07:05:37 GMT

I found the main problem : the Lastmodified date is stored like this (in SalesForce) :"yyyy-MM-dd'T'HH:mm:ss'.000Z'"
What conversion shall i do to this field to get : mm-dd-yyyy ... would be perfect... as a string maybe ?
Same question for getdate() to get todays date... as a string too ?... (same type the last modified date) to be able to compare the two.

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

NNekkanti1658462243 — Mon, 13 Feb 2023 08:07:56 GMT

Hi team write lastmodified date = getdate-1 in tsalesforce component under query condition.Please help me out .I am getting below error if i use condition. It is very critical

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

Anonymous — Mon, 13 Feb 2023 08:26:22 GMT

@Navyasri Nekkanti , can you try to query the lastmodified date field from Salesforce and see what's the date format is retrieved?

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

NNekkanti1658462243 — Mon, 13 Feb 2023 08:29:58 GMT

Hi Shong, Thank you for response Date Format : 2019-03-01 00:23:11.000 Regards N Navyasri Engineer

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

Anonymous — Mon, 13 Feb 2023 08:42:46 GMT

The lastmodified date contains date and time part, you only want the date part =currentDate-1?, eg:

"...where lastmodifieddate='2023-02-12'"

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

NNekkanti1658462243 — Mon, 13 Feb 2023 08:44:42 GMT

Date and datetime,both are fine Sent from Mail<> for Windows

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

Anonymous — Thu, 16 Feb 2023 08:07:18 GMT

@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