DateTime Editor does not update table on save of DBNull

[JimF (Jim Fairchild)]

Since (I believe) the oTrans.Upate() is essentially the same as pressing save, adding it just causes the DTE to display the date that happened after pressing Save.

After much testing, it seems that if you bind a DB DateTime field to a EpiDateTimeEditor and set the value of the bound field to null, it will not update the DB DateTime field. I don’t think the EpiDateTimeEditor is the issue as far as the update is concerned as I am just attempting to set the row/column value to DBNull.Value.

You can update from a BPM, but then have to refresh the UI to reflect the change which as a side note, seems to be a known issue:

UD Date / DateTime fields cannot be nulled from a BPM

Just ran across this bug which seems to be around for a while (It is present in 10.2.200 and 10.2.300 at least) If you have a UD Field of data type (DateTime) or (Date) it appears that you cannot NULL out that date from a BPM and have it show refreshed on the screen without refreshing the screen. Steps to Replicate Create a Date or Date Time Field (UD) Set the field on the UI of a form Populate the field with a date and hit save Write a BPM that sets that date to null Go back to the screen a…

I am still working on this. If I find a reasonable solution I will post here.