Hi All,
I am creating a form where the user will select the dates from a lookup column. I only need the user to see items that have been created on the same day.
I have this formula another user helped me create, but although there are no errors, the drop down does not display ANY choices.
This is the formula I'm using:
ForAll(Choices([@'CCP 3 Direct Observation Verification'].'CCP3#DateChecked'),
Text(DateValue(Value)) in Filter(
'Form 117 CCP # 3 Carcass Zero Tolerance Check',
Created >= Today()
).Created)
Here is proof that it works properly:
When I however on 'Created' I see the option appear from today.
When I however outside all of the parenthesis, all of the values appear as false, even the value that should return as true.
Is there anything I can do to improve my formula?
If you know of a way to simply sort these dates in descending order, that works too!
Edit: I have found a solution to the second question, a way to sort the dates in descending order.
Sort(Choices([@'CCP 3 Direct Observation Verification'].'CCP3#DateChecked'), Value, Descending)
