[AccessD] Date Compare

I would make a table to fit in between that has one field with the
individual dates and another field with the week ending date. Then you
do a three table join. It's common to have a Date table in a data
warehouse application where you have a record for each possible date
and then have various values for that date set, the Fiscal period it
is in, The fiscal year week it is in, things like that. Then you join
in that date table whenever you need some of that stuff and you don't
have to resort to calculations or formulas. Works pretty slick.

GK

On 1/10/07, Keith Williamson <Kwilliamson at rtkl.com> wrote:
> Hi all,
>
>
>
> Anyone have a solution for how to link two tables with different dates?
>
>
>
> I have a Payroll Paid table, with field: DatePaid
>
>
>
> I also have a Timesheet table, with field: TimesheetEndDate
>
>
>
> The DatePaid field is a bi-weekly date.  The TimesheetEndDate field is
> usually a weekly date, but occasionally there is a supplemental
> timesheet date.  What I am trying to do is link the Timesheet table for
> all dates that fall within the 13 days prior to, and including, the
> DatePaid.
>
>
>
> So, for DatePaid of 11/29/06.....I want to link all Timesheets with a
> TimesheetEndDate falling 13 days prior to, and including 11/29/06.
>
>
>
> Anyone have a solution for that?
>
>
>
> Thanks kindly, for any help.
>
>
>
> Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com
>
> RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
> 21231-3305
>
> 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
> <http://www.rtkl.com/>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com