Forum Discussion
Conditional formatting date uses mm-dd-yy in stead of dd-mm-yy in lookup column.
In list 1 I am using a date field with out-of-the-box conditional formatting (green-yellow-red) of this column. Regional settings of the site are Dutch: dd-mm-yyyy. Everything works fine. Next st...
VJK22 It might be using UTC time default date format of mm-dd-yyyy in extended lookup columns.
Check if toLocaleDateString() operator in JSON formatting helps you to convert date column based on user's locale.
Documentation: json-formatting-syntax-reference
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
