Date changes to 01/01/2001 when making any update to the row

[Tony5890]

I have an app for appointments, when I make any changes to any column of a row, the date of the appointment first changes to "Invalid date" for a few seconds and then returns to original value... but if I make another change when the date shows "Invalid date", it changes to 01/01/2001.  This messes up the user experience so bad and causes him to lose some appointments.

   

[lynchk21]

Sounds like you might have the "reset on edit" option selected for the date column? Or do you have a bot that runs on edits maybe?

[Tony5890]

Thanks! but I already checked that option and i have it unselected... neither I have any bots that can change data on that table

But thanks for your reply!

[AleksiAlkio]

Is the date selected manually? What is your column type in your data source?