Re: [SQL] calculation of pay based on dates

2007-07-13 Thread Gary Stainburn
On Friday 13 July 2007 11:12, Penchalaiah P. wrote: > Hi ... > > I want to fix the pay based on joining date and antedate...antedate is > the last date... > > Joining date is 01-07-2007 > > Antedate is 04-07-2007.. > > > > On joining date I will fix the pay but before fixing the pay I will > check

[SQL] calculation of pay based on dates

2007-07-13 Thread Penchalaiah P.
Hi ... I want to fix the pay based on joining date and antedate...antedate is the last date... Joining date is 01-07-2007 Antedate is 04-07-2007.. On joining date I will fix the pay but before fixing the pay I will check whether antedate is there or not, if its there then I will see diffe