JSON Formula Error [ =Date() ]

Question

I have a column date which was working with JSON&nbsp; "customRowAction" &gt; "ActionInput" until some days ago, but suddently simply got me the following error:&nbsp;As-is&nbsp;"=Date(getDate(@now) + '/' + (getMonth(@now) + 1) + '/' + getYear(@now) + ' ' + substring(toLocaleTimeString(@now), 0, 5))"&nbsp;&nbsp;When I try to choose the value myself, I has the same exactly structure defined inside formula =Date() as above, but it is only use it and I had the error.If I try to use the same formula in "txtContent" I also have the same error as above.&nbsp;I also tried using&nbsp;@now and has the same issue.I also tried using the same structure of the Regional Locale set up for the SharePoint (which is: United States) and I also have the same issue.&gt;&gt;&gt;&gt; I have tried many other ways, as below, and nothing works:&nbsp;2Digits Day-Month (test)&nbsp;"=Date(padStart(toString(getDate(@now)),2 ,'0') + '/' + padStart(toString(getMonth(@now)+1), 2 ,'0') + '/' + getYear(@now) + ' ' + substring(toLocaleTimeString(@now), 0, 5))"&nbsp;&nbsp;

markburrage42 · Answer

Sorry this is not a solution but a repetition.

I am also using a button > customRowAction > actionInput to update a date column by simply using @now. This worked fine until a little while ago then started showing the same error as above.

If anyone has any solutions it would really be appreciated.

Thanks Mark

markburrage42 · Answer

I've just found a solution"=getYear(@now)+'-'+(getMonth(@now)+1)+'-'+getDate(@now) + ' ' + toLocaleTimeString(@now)"Very similar to that above but with date and year swapped which may have something to do with time settings. In any case it worked for me and I found it in this useful articlehttps://techcommunity.microsoft.com/t5/microsoft-365-pnp-blog/quick-sharepoint-approvals-using-list-formatting-json-to-set/ba-p/2984496

Forum Discussion

JSON Formula Error [ =Date() ]

Resources