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.
Hi MichaelD,
I see the date you hardcoded seems to be in format "mm-dd-yyyy" and in the second photo you can see it is in the format "dd-mm-yyyy" this can be a problem too
I created a DateTime column in SharePoint and set it to display only the date (excluding the time). I then updated a specific record by converting the DateTime (format "dd-mm-yyyy") value to just the date using the .to_date formula, and the row was successfully updated.
I hope this helps! I've attached screenshots below for your referenceโplease take a look.
Thank you for your reply, but it doesn't work on my SharePoint site.
I have tried to change the code, but still get the weird error from SharePoint. as stated in my first post.
MDIVDATE(MDIVDATE): 2025-05-16This is the input value i get after changing the value to below formula.
Do you have any suggestions on what can be the issue?
