Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Fetch data whose date is less than 10hrs from the existing date!

Hi Team, I’m trying to achieve a filter condition but haven’t found any luck so far. My data has a field as Last_Updated which has date stored in the format 2022-06-23 03:54:45 I want to cons...
expression_language
pattern
sample_pipeline
transform
  • bojanvelevski's avatar
    bojanvelevski
    4 years ago

    Than I go back to my original statement. This expression will do the job:

    Date.parse($Last_Updated) > Date.now().minusHours(48)

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago

@bojanvelevski: From the documentation on Diff snap, it can be understood that the input documents should be flat files. For my use case, I will have to compare 2 different systems, one is snowflake and another is Salesforce plus after the comparison I need to update Salesforce.

Does Diff snap allow us to update records to Salesforce if we put a salesforce upsert/salesfroce update after Modified path of Diff?

Thanks!