Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DATEDIFF - Calculating Age in days

 

 

I'm getting this erorr when trying to calculate the days between two dates.

  • Hey Anonymous,

     

    I have never seen this issue, but I suspect it is because of the Time part of the date. Try changing the Date format from "Date/Time" to just "Date" and try the formula again.

     

    Hope this helps,

     

    Alan

2 Replies

  • alanhodgson's avatar
    alanhodgson
    Icon for Solution Supplier rankSolution Supplier

    Hey Anonymous,

     

    I have never seen this issue, but I suspect it is because of the Time part of the date. Try changing the Date format from "Date/Time" to just "Date" and try the formula again.

     

    Hope this helps,

     

    Alan

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you, that did the trick.