Date increment is not working properly

[rammudali]

I am developing a time sheet module for a construction proj.

date increment after first loop in "Do While nstdt <= nenddt " statement is not working properly and date comparison in "select case" statement is not working properly.

And also is there any better method to make a time sheet module.

please help me to correct the coding.

Thanks in advance

 

[jdraw]

http://www.techonthenet.com/access/functions/date/weekday.php

When you dim variables

These are valid/correct and do what you think.
Dim date1 as Date
Dim Date2 as Date, icount as Integer


This approach does NOT do what you think.
Dim Date1, Date2, Date3 as date

Here Date1 and Date2 will be Variants, Date3 will be a Date
I recommend you create relationships between your tables, before getting into the nitty-gritty coding.

For a great debugging reference see:
http://www.cpearson.com/excel/debug.htm

 

[rammudali]

Dear Jdraw,

Thanks for your reply.

please note that I want to insert the worked hrs and allowance to a different table itself which is independent.

i tried all ways i know but logic working but date increment is not working properly

I would requst you to correct the code which will be a great help to me.


thanks