DateDiff Limit

[hgus393]

Hi,

when running a custom function finding the number of days between two dates I use datediff. However I get overflow when the date is too far away in the future. Is there a maximum or a limit on the number of days (or date) that datediff can return?
Cheers
Bob

 

[hgus393]

Ahem..figured it out had defined datediff variable as integer ...

 

[vbaInet]

It would have been useful to see the function in your first post hgus. Glad you got it working though.