does it? i get it giving exactly the same answers as yours? and so did Brian?
?WeekStart(3,2006)
09/01/06
?weekstart2(3,2006)
09/01/06
fair comment, i was going for brevity over readibility :)
i see it more as malleability than laziness. a hard coded function means your sales...
a mutation may go unused for many many generations before being expressed
you have two copies of almost every chromosome, if one copy is mutated, it may be the non dominant copy or the mutation may be in junk DNA
it's not like Heroes where all of sudden someone can walk through walls... :)...
Function WeekStart2(intWeekNR As Integer, intYear As Integer) As Date
WeekStart2 = DateSerial(intYear, 1, 1) - ((DateSerial(intYear, 1, 1) + 5) Mod 7) + (intWeekNR - 1) * 7
End Function
owzat? (assumes week 1 is the week containing 1/1/YYYY)
fair enough. but i find that weeks are bespoke to each company. when does jan 1 lie in week 2, do you have 53 weeks that year etc etc
most companies just have big calendar lookup tables
how does yours know if jan 1 is in the first week or not?
is there any way of switching off the really annoying
"Compile error" when you get the syntax wrong and it colours the line red
i just want to be able to move about copying and pasting without having the damn pop up
:mad:
looks good, i have a similar thing and was wondering how to switch that damn signature on :) GetInspector, that's not obvious!
oh and i have written some code to turn a SQL string into a html file that i use with it...