Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    90

    Question Unanswered: Fiscal Year query?

    I need to do something so that I can look at a seminar date and determine which fiscal period it is in. For example if the fiscal period is like July 1, 1997 through June 30, 1998 then the seminar record should be grouped as FY1998... etc...

    All my data is already in a table called Seminar so I thought that it would be easy to add another field called FiscalYear and then calculate my value from that. But how could I do that? I guess with a query. But how can I write a query that does that? A query solution would be ideal because I would use the query in many places. The starting and ending month and day of the fiscal year are given in a table. The query should look at the year of the seminar date and the fiscal year start and end dates to determine the fiscal period.
    Thanks - Lenni

    I am sorry this is very vague but all help would be appreciated. Thanks
    Last edited by lskuff; 06-09-04 at 20:33.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Code:
    select year(dateadd("m",6,seminardate)) as fiscalyear
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2004
    Posts
    90
    Thank you very much! that worked great

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •