Date out of Date out of range (-740126)

Hi All,

We are using Orcle Database for our DB in Appian. Recently, our client want to display last updated record at the Top on Grid list. In order to fullfill this we introduce the UpdateOn[Oracle datatype date and Appian Datetime] column in our table, as we have more older record, it was hard to show updateOn date on them. We copied Created date[datatype Date in Oralce and  In Appian Datatime]. We see there are lot of record( more than 12000) which display date out of Range on updateOn column in Appian. Kindly see below.

Date out of range (-739921)

Date out of range (-739921)

3/10/2009 2:06 PM EDT

3/11/2009 3:10 PM EDT

Kindly help me here.


  Discussion posts and replies are publicly visible