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)

bojanvelevski's avatar
bojanvelevski
Valued Contributor
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

Sure @bojanvelevski, I will test it out and keep you posted.
For now, I’m not seeing any data in my filter snap, may be there is no record that suffice the condition but I will manually change the data from the source system and test if this works.

As always, appreciate your help on this one too.