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.
Discussion posts and replies are publicly visible
Got the requirement. Thankyou
Care to post your solution for people who would have this question in the future?
Sure, Thanks.
using the forEach loop
a!forEach{
items:set of records,
expression:and(current date>=fv!item.startdate,
currentdate<=fv!item.enddate)
}
You might want to try this for easy readability and access to code.