How to use DIFFINDAYS function in calculated field in dataverse

Question

I want to get the difference between today and another date time column in dataverse and put it into a column using calculated field but when I try to use DIFFINDAYS, it doesn't work. See below screenshot.

Thank you in advance for your help!

Answer 1

Hi Charlie Matanguihan,

Thank you for reaching out to us on Microsoft Q&A forum.  

To implement the DIFFINDAYS function in a calculated field in Dataverse. Please follow the below steps.

1. Access Your Dataverse Table:
   • Open the Dataverse environment and navigate to your specific table.
2. Add a New Calculated Column:
   • Go to the "Columns" section.
   • Click on "Add Column" and select "Calculated" as the type.
3. Write the Formula:
   • In the formula editor, enter
   • DIFFINDAYS(TODAY( ), [YourDataColumn])
   • Replace [YourDateColumn] with the actual name of your date column.
4. Save and Validate:
   • Click "Save" and then validate to check for errors.
   By following the above steps, you should be able to successfully create a calculated field that utilizes the DIFFINDAYS function. If you are still facing any issue, please let us know in the comments. We are glad to help you. If the information is helpful, please Accept Answer so that it would be helpful to community members.