Skip to main content
lavanyam0003
lavanyam0003
Known Participant
Jun 10, 2023 6:16 PM UTC
Question

check the given date between two dates

Hi All,

I had the set of data in table like "startDate" as 2023-01-01,2023-03-01,.... and "endDate" as 2023-02-28,2023-04-30.... now I need to check today is available in between of which set.


Please suggest if anyone have an idea.

Thanks in advance.

    4 replies

    lavanyam0003
    lavanyam0003Author
    Known Participant
    Jun 10, 2023 6:59 PM UTC

    Got the requirement. Thankyou

    mathieud0001
    mathieud0001
    Genius
    Jun 11, 2023 12:57 PM UTC

    Care to post your solution for people who would have this question in the future?

    lavanyam0003
    lavanyam0003Author
    Known Participant
    Jun 13, 2023 6:19 AM UTC

    Sure, Thanks.

    using the forEach loop 

    a!forEach{

    items:set of records,

    expression:and(current date>=fv!item.startdate,

    currentdate<=fv!item.enddate)

    }

    Terms & ConditionsAccessibility statement