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 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

  • If your data is a field like languages, you could use $languages.map(obj => obj.language) to pull just those values out.

16 Replies

  • dmiller's avatar
    dmiller
    Former Employee

    Interesting, I now it’s a category by category setting with the owner of a thread and staff can mark something as a solution, but I’m not seeing it either. Let me take a look.