Calculating the days with Format()

[stojko89]

Hi!

What I'm tryn to do is calculate days that have passed from one date to another....it's simple but I'm haveing problems with it....
This is my code:

Please Login or Register  to view this content.

It kind of says Overflow but if I put it a bit different I don't get the correct number of days.
x.Value is a date in a range.

Please help

[antoka05]

You could use this code:

Please Login or Register  to view this content.

I think that when you use Format instruction it transforms Date in string and then you can't do arithmetic operations with string, before you need to do the calculations and then apply the Format to the result
Regards,
Antonio

[stojko89]

You could use this code:

Please Login or Register  to view this content.

So the first Format code didn't work correctly.
But the second one works perfect!
So thank you very much!