rfe #1653 New data validation feature and datetime type

Signed-off-by: Madhura Jayaratne <madhura.cj@gmail.com>

1 files changed, 6 insertions, 2 deletions

diff --git a/js/tbl_change.js b/js/tbl_change.js
index 9f77872a56..4acde2e7db 100644
--- a/js/tbl_change.js
+++ b/js/tbl_change.js
@@ -400,6 +400,7 @@ AJAX.registerOnload('tbl_change.js', function () {
                 return true;
             } else if (theType == "datetime" || theType == "timestamp") {
                 var tmstmp = false;
+                dt_value = dt_value.trim();
                 if (dt_value == "CURRENT_TIMESTAMP") {
                     return true;
                 }
@@ -410,8 +411,11 @@ AJAX.registerOnload('tbl_change.js', function () {
                     return true;
                 }
                 var dv = dt_value.indexOf(" ");
-                if (dv == -1) {
-                    return false;
+                if (dv == -1) { // Only the date component, which is valid
+                    if (!  isDate(dt_value, tmstmp)) {
+                        return false;
+                    }
+                    return true;
                 } else {
                     if (! (isDate(dt_value.substring(0, dv), tmstmp)
                         && isTime(dt_value.substring(dv + 1)))) {