topic Re: Setting a date / datetime in SharePoint in Workato Pros Discussion Board

Setting a date / datetime in SharePoint

MichaelD — Wed, 18 Jun 2025 09:41:52 GMT

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.

Re: Setting a date / datetime in SharePoint

Bhagya_pola — Wed, 18 Jun 2025 18:02:19 GMT

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.

Re: Setting a date / datetime in SharePoint

MichaelD — Thu, 19 Jun 2025 09:36:31 GMT

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-16

This is the input value i get after changing the value to below formula.

Do you have any suggestions on what can be the issue?

Re: Setting a date / datetime in SharePoint

Bhagya_pola — Thu, 19 Jun 2025 11:12:05 GMT

Try in this way

Re: Setting a date / datetime in SharePoint

MichaelD — Fri, 20 Jun 2025 08:00:57 GMT

MDIVDATE(MDIVDATE): 16/05/2025

This is my input, and this is my error message:

MDIVDATE: Enter a date like this: 23/02/2012

I'm worried that it is our SharePoint Online that is broken, I really don't understand this error.

Re: Setting a date / datetime in SharePoint

gary1 — Fri, 20 Jun 2025 16:15:34 GMT

This is definitely weird. Are you able to query a different DateTime field to see an example of how the API returns the value? The format might be different than all of the formats you've tried as input so far.

Re: Setting a date / datetime in SharePoint

MichaelD — Mon, 23 Jun 2025 09:21:24 GMT

@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.working correct date
Not workingWorkingDiff