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.
Need Help
  • alanhodgson's avatar
    alanhodgson
    9 years ago

    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

alanhodgson's avatar
alanhodgson
Icon for Solution Supplier rankSolution Supplier
9 years ago

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
    9 years ago

    Thank you, that did the trick.