Wrong Entry of Date time in SharePoint

Occasional Visitor

Hello Everyone,


I have a big list in SharePoint and I used "Calculation" to some items, so I can build up relationships among different columns.


But today when I put two new entries in the list, I found that the time (date and time) I set as default value became something really ridiculous (1899 Dec. 30 ?????) instead of the one I set (2020 Feb. 4) ... I don't know what happened. Maybe some of you had the same problem before and could be so kind to help me a bit? 


Thank you very much!!


Best regards



(the last two new entries in the picture below are so wrong. There should've been the default date  value I set)






0 Replies