Ok, that makes sense. I have all the payperiods specified in a table to
begin with, then just query selecting all >= start && <= end.
Thanks,
- Darren
On Tue, 2002-11-12 at 11:29, Peter Beckman wrote:
> Put the dates for employees into one table.
>
> In another, put the payperiods.
>
> You cou
Put the dates for employees into one table.
In another, put the payperiods.
You could populate the payperiods table for the next 90 years if you wanted
if it is always on a 2 week schedule.
To look at past payperiods:
select start, end from payperiods where start = '$querydate';
Or just date
Our payperiods will always be 2 week increments.
So if I specify a starting day in the database I need to have that
starting day always updated to the current starting day. (when we switch
to the new payperiod), so as Jerrad mentioned I could use a cron job.
But how would I be able to look at pa
> To: Darren Bentley; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] payperiods
>
>
> I would think that the hard coded date is the way I'd do that.
>
> maybe not neccessarily a start_dt, but maybe a pay_pd_st
> date. This date is just the date the payperiod falls on. You
I would think that the hard coded date is the way I'd do that.
maybe not neccessarily a start_dt, but maybe a pay_pd_st date. This date is just the
date the payperiod falls on. You increment it once every two weeks. Have a table in
your db with that field and variable. maybe hardcode the very fi
$nextpayperiod = mktime(0,0,0,$month,$day+14,$year);
$humanreadabledate = date("r",$nextpayperiod);
where $month is numeric month, $day is the last payperiod day (1-31), and
$year is the year of the payperiod.
$nextpayperiod will equal the unix timestamp of 14 days from the last payperiod.
Peter
