Hi there,
I have "Date and Time" Column and the value is "8/31/2021". If I would like to change the format from "8/31/2021" to "2021/8/31", how should I do by using JSON.
Thanks
Hi there,
I have "Date and Time" Column and the value is "8/31/2021". If I would like to change the format from "8/31/2021" to "2021/8/31", how should I do by using JSON.
Thanks
Hi @SHUOH-8693 ,
Unfortunately, it is not currently possible to apply custom string formats or to extract portions of dates using JSON column formatting.
However, you are able to do this with standard calculated columns:
=TEXT([YourField],"yyyy/mm/dd")
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
7 people are following this question.