khwindlake

Handling null dates in the Edit widget

Discussion created by khwindlake on Nov 10, 2017
Latest reply on Feb 2, 2018 by andrew.murphy@niwater.com

Hi All,

 

I have a web app with a feature class and a related table.  In the related table there are numerous date fields to track when specific stages of a project are reached, like DateSubmitted, DateRejected, DateResubmitted, DateInvoiced, etc.  In all there is around 30 different date fields in the table.

 

My problem is that when I start editing with the Edit Widget, open the feature table, then open the related table, and then update one date, let's say DateSubmitted, from null to the current date (or any date), the rest of the date fields (DateRejected, DateResubmitted, DateInvoiced, etc.) are also updated.  They use to be empty, but now they display 12/30/1899 12:00.00AM.  See below...

 

I've looked for a setting in the app or the widget but don't see anything.  I've also ensured that Null values are allowed in the attributes.  

 

Can anyone point me in the right direction?

 

Thanks in advance,

Keith

Outcomes