A Client Script used to set a Date/Time field to empty in Tablet Mode may return the unexpected value 1969-12-31 19:00:00

When using a Client Script to try to set a Date/Time field to empty in Tablet Mode, the value returned will be 1969-12-31 19:00:00.

When leaving the Date/Time field blank, the system is inputting a negative value to calculate the unexpected date. No error message is thrown.

 

Activate 'Tablet Device Support - iPad with iOS 6+' plugin

 

1) Go to System Definition > Tables

2) Search for Incident and open

3) Under Column Tab, click New

4) Set the following:

 

Type: Date/Time

Column label: Tablet Date

Column name u_tablet_date

 

Leave everything else default

5) Save

6) Go to Incident > Create New

7) Right-click header > Configure > Form Layout

8) 'Under Form view and section' > Section, scroll down to New…

9) Section caption: Tablet Test

10) Click 'OK'

11) In the left 'Available' column, find 'Tablet Date' and add to the 'Selected' column

12) Click 'Save'

13) Go to System Definition > Client Scripts

14) Click 'New'

15) Set the following (I have also attached the client script  sys_script_client_71803cb0747022004e829bd26ebc8fba.xml):

 

Name: Tablet test

Table: Incident[incident]

UI Type: Both

Type: onLoad

Active: check

Global: check

Script: 

function onLoad() {

 alert(g_form.getValue('u_tablet_date'));

 g_form.setValue('u_tablet_date','');

 alert(g_form.getValue('u_tablet_date'));

}

 

16) Save

17) Go to Tablet Development > Switch to Tablet Mode

18) Go to Incident > Create New

19) Notice the alert set to 1969-12-31 19:00:00 - Tablet Date will show 12/31/1969 7:00 PM. The Date/Time field should instead be left to empty with no value.

 

After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make these decisions lightly, and we apologize for any inconvenience.