I am trying to find records where the records fall within the effective and expiration dates on a record.
I tried unsuccessfully to use the function today():
a!recordFilterListOption(3,"CURRENT",a!queryFilter("today()","between",{"reqeffdt","reqexpdt"}))
So I added a (date)field to the view "today"
a!recordFilterList(
name: "Status",
options: {
a!recordFilterListOption(1,"FUTURE",a!queryFilter("reqeffdt",">",today())) ,
a!recordFilterListOption(2,"PAST",a!queryFilter("reqexpdt","<",today())) ,
a!recordFilterListOption(3,"CURRENT",a!queryFilter("today","between",{"reqeffdt","reqexpdt"}))
} )
Even though today,reqeffdt and reqexpdt are all type: DATE
I am getting the error.
Discussion posts and replies are publicly visible