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.
App: 1000789
Date out of range (-739921)
App: 1000790
App: 1000796
3/10/2009 2:06 PM EDT
App: 1000800
3/11/2009 3:10 PM EDT
Kindly help me here.
Regards,
Discussion posts and replies are publicly visible
In the DB itself, do those rows have valid dates? As opposed to, say, NULL values? In what manner was this data originally populated? If you manually edit the value found in the target column of one of those rows, directly in the DB, does it fix the front-end output from Appian?
Hi Mike,
Thank you. This was Out DB issue and most was bad data. This has been take care by our DB team.