LinkedIn
Twitter
Hello, first of all thank you for the help that you can give me.
I have a Slice table in which I have created a simple expression but I can’t get the result
IFS(
[Fecha vencimiento del certificado]>=DATE(“20/10/2021”),
AND(
ISNOTBLANK([Fecha vencimiento del certificado]),
[Fecha vencimiento del certificado]<=NOW()+15
)
)
With this expression it should show only those records that are greater than October 20, 2021 and those records where the date is today plus 15 days
Solved
1 ACCEPTED SOLUTION
Thank you very much @WillowMobileSystems I am using IFS because 2 conditions must be met first that the records are made after October 20 and that on the other hand it is not empty and is less than or equal to today plus 15
I have found the error, after investigating for a while the format of the date must be first the month then the day and lastly the year.
Thank you very much for the recommendation.
