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

[darshthakkar]

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 consider only those records whose date is less than 10 hours than the existing date. How can I achieve this? Shall I use a mapper or a filter snap and I would really appreciate if the logic behind this can be shared.

If the format of the date that is stored in the Last_Updated needs to be transformed as well, please let me know.
Thanks!

Regards,
Darsh

[darshthakkar]

I agree to your comments on opening a new thread. I will do the needful.

Regarding Diff snap, I haven’t used it so far, or to put it correctly, I wasn’t even aware of that until today.
So, I have used Joins, Inner join to be precise and then routing the error view to get the actual output.

The concerning part is duplicates so how would I eliminate those will require some serious brainstorming from my side.

Thank you for your suggestion on new thread.

Regards,
Darsh

[darshthakkar]

Discussion continued on Eliminating duplicated records based on the Last Updated Date