A user asked me if they can use the wildcard characters when they filter a form on a Date Field.
The user is right clicking in the field, then next to "Filter For" they are typing in "12/##/2002" to find all the records from Dec. 2002. When they hit Enter, an error message pops up and says "The Expression You Entered Has An Invalid Date Format".
I was not sure if I was trying to filter incorrectly in the date field, or if this is just not possible.
If anyone has any ideas let me know.
Thank you for your time and efforts,
T.J.
The user is right clicking in the field, then next to "Filter For" they are typing in "12/##/2002" to find all the records from Dec. 2002. When they hit Enter, an error message pops up and says "The Expression You Entered Has An Invalid Date Format".
I was not sure if I was trying to filter incorrectly in the date field, or if this is just not possible.
If anyone has any ideas let me know.
Thank you for your time and efforts,
T.J.
