If(
Date(2025,1,18) < Today(),
"Yes",
"No"
)
Hello, I see that you are trying to use dates to make certain decisions. However, you are using (18/01/2025)
instead of DateValue("18/01/2025")
. When we use only (18/01/2025)
, the compiler assumes we are trying to divide the numbers 18, 01, and 2025.
To compare dates, both values need to be in date format, and there are two easy ways to achieve this:
18/01/2025
inside a variable and then compare it with Today()
.18/01/2025
as text inside DateValue
.Here’s a possible solution:
1.
2.
I hope this was helpful.😀
Stay up to date on forum activity by subscribing.