Is there any option by which we can use date() function in a virtual table
the logic I wanted to implement in a virtual table is
(firstdate <= date()) AND ((lastdate is null) or (lastdate >=date()))
But this is not getting validated...
so is there any option by which i can use date() option in virtual table