I have created a DateTime column in SharePoint, and told it to only show the date.
When I Update the field I get an exception, and I have tried just about anything I can think of.
I have tried hardcoding the date using the Date/Time picker in Workato, but it just wont work.
I have tried converting the date to the requested format, but after a little google search I found that the error message is pretty much standard.
What is the magic trick to get Workato to enter Dates into SharePoint?
Below are screenshots, first is the value when entered with datepicker, second is the error message, and third is what is sent.
@gary1 and @Bhagya_pola thank you for your input, I'm getting closer to a solution (I think).
As shown in the pictures below, they look much alike, the difference is automatic or manual date, and the manual works, and the automatic doesn't!
When I look at the input values, the one that works is 2025-06-10, but it turns out in SharePoint to be 6th of October, and not 10th of June. Hence I understand now why 2025-05-16 doesn't work, as it isn't a real date.
As it swaps the D and M, I thought it would be as easy as changing those values, so 16-05 swapped from 05-16
When hardcoding the date, I get this: Data format error in Microsoft Sharepoint. Invalid Date/time for 'MDIVDATE(MDIVDATE)': '2025-16-05T00:00:00'.
I tried to swap 2025-06-10 to 2025-10-06 as it went straight through.
