Knowing how many days are between two dates

[robman70]

Hello all,
i have a program with two text fields, txtCheckIn and txtCheckOut, a check in date is entered into txtCheckIn and a check out date is entered into txtCheckOut, then i get the information and put them into variables (both declared as date) what i want to know is how can i print days between, like if someone put 2/27/2003 in txtCheckIn and 3/2/2003 in txtCheckOut how can i make the program print
2/27/2003
2/28/2003
3/1/2003
3/2/2003

any help is appreciated
Thanks

 

[srusti]

dear robman
Try useing datediff() , you will find the difference between two dates
bye
Try it for me...

 

[strongm]

As srusti says, try investigating datediff. Then do a keyword search in this forum for any one of the many threads we've had on this topic; they discuss some of the failings of the datediff function, and explore ways to deal with them.

 

[CCLINT]

Dim dtCurrDate As Date
Dim dtStart As Date
Dim dtEnd As Date

dtStart = CDate(txtCheckIn.Text)
dtCurrDate = dtStart

Do
Debug.Print dtCurrDate
dtCurrDate = dtCurrDate + 1
Loop Until dtCurrDate=dtEnd
[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}