I have some custom metadata used to configure various scheduled batch jobs. The custom metadata fields allow entry of a string that is used in a SOQL query as a date literal filter
For example, the field should support:
as defined in the SOQL documentation or support an ISO8601 datetime such as
How can I verify that the text entered is a valid date literal using a Validation Rule?