Forum Discussion
Sp list - calculated column to add numbers to a date, does not give a new date
So I have a date column. I also have a calculated column which is basically =date+10 Most of the time this works and I get a new, correct date. Sometimes, I just get a number, say 256. Odd...
In the calculated column settings you can specify what format the returned value is. From memory one of the options is a date format. Have you made sure that this is selected?
Yes, its listed as a date. Most of the time it works, but sometimes it doesn't.
The way it works is: we copy info from a spread sheet and paste it into a SP list. That info is then pushed into the 2nd SP list by Power Automate. It's this 2nd SP list where the calculated column is
Odd thing is, all it takes is for the record to be updated once to correct it
That does sound a little quirky. Both lists use the same locale for their date formatting?
