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

Stephanie

 

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

 

clipboard_image_0.png

 

 

clipboard_image_1.png

0 Replies