DataDiff

Hello I am trying to find the number of days in between 2 dates and when I use the following code it does not work right all the time. The problem I believe is when I subtract dates from 2 different YEARS. Does anyone have any suggestions on this....

txt1.text = DateDiff("d", txt2.text, Date)

Does txt2.Text need to be converted to a date variable or is it not formatted properly? It seemed to work all right for me in VB6.

Hi VBAmateur,

I'm with bsmith, I ran it on VB6 without any problems. It will be a lot easier to help you if you provide example dates that are giving you trouble.

All the best.