Fiscal Date Period

[Guest]

I have a table of data that has a StartDate. I am trying to assign a Number
that represents the Fiscal Period the startDate Falls into.

I have another table that lists the FiscalStartDate, FiscalEndDate and
PeriodNumber:
09/26/2004 (FiscalStartDate)
10/23/2004 (FiscalEndDate)
1 (PeriodNumber)

In the first table a StartDate of 09/27/2004 falls between 09/26/2004 and
10/23/2004. Therefore the PeriodNumber is 1. I am trying to create a query
or expression to get the PeriodNumber assigned to each record on the first
table.

I am sure this is easy, but I am strugling with it at the moment. Any Ideas?

 

[Guest]

I think this is what you need:
select PeriodNumber from tblPeriodNumber
where inputdate between FiscalStartDate and FiscalEndDate