Evaluating Week No.
I wouldn't suggest anything as drastic as not posting to the newsgroups. If
there is nothing you can do about it, then that is the way it is. It just
causes your messages to line up out of sequence (for me at least) - but so
be it.
--
Regards,
Tom Ogilvy
"MahaRaj" wrote in message
...
sorry I forgot to mention.
there a problem with my ISP NTL uk
I have the right time on my system but the the date stamps are from NTL
server so I can not do nothing. I even changed my system time one hour
later
but still nothing happend.
MahaRaj
PS: I will try not to post to the ngs. :)
"Tom Ogilvy" wrote in message
...
Check your system clock. You are posting in the future.
--
Regards,
Tom Ogilvy
"MahaRaj" wrote in message
...
Hi I am working on this PAYSLIP sheet. I want to add this feature in
payslip
to find out the Week NO. on the basis of w/e dates entered which could
be
different from the standard table (below).
i.e If date enterd is 07/05/2004 then its lessthan 10/05/2004 and
greaterthan 03/05/2004 than week no=5
It would have been easy if the options were just 2, but how can i
evaluate
it from the table(below)?
I do not know how to start! any ideas please
W/E Week No
12/04/2004 1
19/04/2004 2
26/04/2004 3
03/05/2004 4
10/05/2004 5
17/05/2004 6
24/05/2004 7
31/05/2004 8
07/06/2004 9
14/06/2004 10
21/06/2004 11
28/06/2004 12
05/07/2004 13
12/07/2004 14
19/07/2004 15
26/07/2004 16
02/08/2004 17
09/08/2004 18
16/08/2004 19
23/08/2004 20
30/08/2004 21
06/09/2004 22
13/09/2004 23
20/09/2004 24
27/09/2004 25
04/10/2004 26
11/10/2004 27
18/10/2004 28
25/10/2004 29
01/11/2004 30
08/11/2004 31
15/11/2004 32
22/11/2004 33
29/11/2004 34
06/12/2004 35
13/12/2004 36
20/12/2004 37
27/12/2004 38
03/01/2005 39
10/01/2005 40
17/01/2005 41
24/01/2005 42
31/01/2005 43
07/02/2005 44
14/02/2005 45
21/02/2005 46
28/02/2005 47
07/03/2005 48
14/03/2005 49
21/03/2005 50
28/03/2005 51
04/04/2005 52
|