Conditional Formatting – Incorrect Date Comparison of Unbound Date Controls

By | 2024-03-07

If you have two unbound text boxes on a form, and the likely scenario is for a Date Range for Report Criteria, you may want to warn the user when the End Date is before the Start Date but get the wrong result.

In this application we are using the date format dd/mm/yyyy as set in the Regional Settings when is set to English (Australia). The controls’ format property is set to Short Date.

So you may use a format condtion (Conditional Format) like the above but not expect the result shown in the next image.

To ensure the correct result, use the International format as part of an expression for comparision.


now that’s better and will work regardless of your Regional Settings.

This issue was documented in Version 2311 Build 17029.20140 Monthly Enterprise Channel