cognito-forms
I’m trying to enable a date related search filter in entries page and I keep getting this error message:
value is not properly formatted
Since I use a simple expression (date is…or date is before…), I suppose this is a glitch.
Is this the case? Or am I doing something wrong?
Entries in Cognito Forms can have an Entry Status of either Pending or Complete. All entries initially have a Entry Status of Pending, but administrators can mark entries as Complete when they have finished processing an entry. You can also quickly filter entries by Entry Status, which makes it easy to work through the current pending list.
We plan to leverage this Entry Status in the future to support additional features, including Save & Resume, where entries that have been saved but not yet submitted would have a different Entry Status, and workflow, where you may be able to define your own Entry Status options and trigger notifications and approval processes.
This Entry Status is separate from the Payment Status, which tracks whether an entry has been paid. This is helpful when you need to fulfill orders, as the Payment Status might be Paid if paid online when the entry was submitted or Unpaid if a cash or check option was selected. Separate from payment, you would use the Entry Status to determine if the goods or services had actually been delivered to the customer.
This is how filtering by Entry and/or Payment Status looks when managing entries:
I am a developer for Cognito Forms.
Although we do not yet offer this kind of search function. We are in the process us adding more functionality to our search option on the Entry page. You can follow our progress as we move forward with this feature over on our Idea Board. Feel free to up vote this feature and other features that you would like to see us work on for future releases.
Best Answer
My name is Parker, I'm a developer with Cognito Forms. The date based searches on the Entries page must be in the US based format, regardless of the localization settings of the form. Unfortunately, for certain date/time formats the date picker control on the search criteria dialog does not handle this properly.
We are currently working on a fix for this, in the meantime you can switch over to the Advanced Editor for the search criteria and enter a valid US date and the search should work as expected.