User Profile
teixeire40
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
JSON Formula Error [ =Date() ]
I have a column date which was working with JSON "customRowAction" > "ActionInput" until some days ago, but suddently simply got me the following error: As-is "=Date(getDate(@now) + '/' + (getMonth(@now) + 1) + '/' + getYear(@now) + ' ' + substring(toLocaleTimeString(@now), 0, 5))" 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. I also tried using @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. >>>> I have tried many other ways, as below, and nothing works: 2Digits Day-Month (test) "=Date(padStart(toString(getDate(@now)),2 ,'0') + '/' + padStart(toString(getMonth(@now)+1), 2 ,'0') + '/' + getYear(@now) + ' ' + substring(toLocaleTimeString(@now), 0, 5))"
