Announcements
Why did the 'date' columns in my Excel spreadsheet - that I imported to a SP list - turn from date format to number format, and how do I fix it?
Hello @PhineasT
That's for the Data type formats between platforms. I recomend you to insert the date value as String.
Hi @PhineasT,
Not sure how you transfer the data from excel to SP list, if you use the flow, you should configure as below:
formatDateTime(addDays('1900-01-01', add(int(items('Apply_to_each')?['Date']),-2)), 'MM/dd/yyyy')
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
