Skip to main content
lavanyam0003
lavanyam0003
June 10, 2023
Question

check the given date between two dates

  • June 10, 2023
  • 4 replies
  • 1 view

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
    June 10, 2023

    Got the requirement. Thankyou

    mathieud0001
    mathieud0001
    June 11, 2023

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

    lavanyam0003
    lavanyam0003Author
    June 13, 2023

    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