[Solution]You can’t use Now(), which is of type DateTime, with the current function in calculated column dataverse
![](https://softchief.com/wp-content/uploads/2024/08/Orange-and-White-Modern-Simple-Technology-YouTube-Thumbnail-1.jpg)
You may get ths error if you use NOW() function in Calculated Column Formula as per below screenshot.
![](https://softchief.com/wp-content/uploads/2024/08/image.png)
Root Cause
In Dataverse, when creating a calculated column, you cannot directly use Now()
(which is a DateTime
function)
Solution
Instead of using Calculated Column use a Formula Column as per below screenshot.
![](https://softchief.com/wp-content/uploads/2024/08/image-1.png)
Now it will work as expected.
![](https://softchief.com/wp-content/uploads/2024/08/image-2-860x289.png)
Hope it helps