I have created a rule to display date time
and currently my loacale of my profile is English (united states)I changed it to english (united kingdom) and now it is giving me this errorAny idea why ?how to resolve it ?
Discussion posts and replies are publicly visible
yes it is anytype variable
"9/30/2025 9:30 AM AKDT"here 30 is a daybut based on my locale it is considering as a month. so that's y error is populating.any idea that how can we identify that 1 st part of date is considering day or month on the basis of locale. that can help me to solve the problem
but that's not relevant. you're still passing the entire dictionary returned by a!fromJson(), which would be like
{ dateTime: <datetime value>}(or per Stefan's runtime example above: )
So the issue is: this rule would need to understand that it's looking for a property named "datetime" from the value being fed into it, if you're trying to feed it the entire dictionary. It's crashing because it is not doing this. Otherwise you should be feeding just the ".datetime" property of the a!fromJson() result.
As I already tried to explain. Your date value is NOT in ISO 8601 format. Appian cannot parse that.
okay. Got it. can you share your code please
yeah this would be what's needed except, as stefan mentioned, the dateTime stored in the JSON string must be in ISO 8601 format, i.e. yyyy-mm-dd.
For your example, where is the JSON string originally coming from? Are you generating it or is it getting generated elsewhere? Can you perhaps give some more overall context to your use case, so we can understand? It seems like we might have gotten a bit lost in the weeds, with respect to what your starting point is, and what you're trying to accomplish overall.
Which code?
Do you have any control on the source of that data? If yes, I highly recommend to change the format to ISO 8601.