View Single Post
  #3 (permalink)  
Old February 4th, 2008, 06:26 AM
mateenmohd mateenmohd is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your response.

It is very helpful.
We have to calculate 364 days.
Yes work completed fill by project manager.
it means that I have to create three date fields

1.strdate
2.insdate (inspection date)
3.enddate (work completed date)

mostly work delayed, work not completed in given date
ie. today date work should be completed, but due to some reasons
work delayed, in this case we have to
1. find work competed % ?
2. number of days work delayed ?

above code will use on mouse lost focus event of insdate form field
(Inspection date) ?

Thanks and regards
Mateen
Reply With Quote