Date Filter on Dynamic Data Block generates an Exception with date format dd/mm/yyyy

[allchannelson]

Prerequisites

Please don't just check the box unless you have done these things...

• [ X ] Put an X between the brackets on this line if you have done all of the following:
  • Did you perform a search at https://github.com/issues?q=is%3Aissue+user%3ASparkDevNetwork+-repo%3ARock to see if your bug or enhancement is already reported?
  • Can you reproduce the problem on a fresh install or the demo site?
  • Did you include your Rock version number and client culture setting?

Description

The Date filter on a Dynamic Data Block does not work properly when the browser local is en-GB, en-HK, or any format that uses dd/mm/yyyy date format. A similar control in Group Viewer works fine.

Steps to Reproduce

1. Set your browser to en-GB
   • Chrome has an extension for quickly doing this (Locale Switcher)
2. Create a new Dynamic Data block
3. Use the following code:

SELECT PersonId 'Id', DateTimeAdded FROM [groupmember] where groupid = 111

4. Turn on Grid Filter
5. Go to the block and use the filter's date picker.
6. Will receive error message regarding Date Format

Expected behavior:

Expect the Date Filter to work

Actual behavior:

Get an Exception regarding the date format.

Versions

• Rock Version: Rock McKinley 11.0 (1.11.0.3)
• Client Culture Setting: en-GB