Dafult Date doesn't work in Datasheet view RRS feed

  • Question

  • I have a SharePoint list which runs calculations based off of today's date. I have a date/time column that defaults to today's date and everything works fine if I add/edit items individually. However, when trying to add an item to the datasheet view, I get an error saying that the list structure has changed. During troubleshooting I noticed that when I try to add an item in the datasheet view, the Date column won't default with today's date, but instead shows ####. If you click on that cell it enters a date of 12/31/1899, then when you click off to a different cell it returns to ####. I have to assume that this issue with defaulting to today's date is whats causing the problems. Any idea?
    • Moved by Mike Walsh FIN Monday, June 27, 2011 4:13 PM admin q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Monday, June 27, 2011 2:58 PM

All replies