Forum Discussion
CONDITIONAL FORMATTING OF DATE COLUMN
Hello Community, Have a column with a date. When I apply conditional formatting, the time pops into the column 12:00:00 AM. How can this be removed? Thanks.
chudson002, You can use toLocaleDateString() function which returns a language sensitive representation of just the date portion of a date-time field.
For Example:
"txtContent":"=toLocaleDateString(@now)"
This will return a result like "7/19/2020". However, results may vary based on user's locale.
Use column formatting to customize SharePoint - Operators
Please click Mark as Best Response if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it Like.