I've done this by simply working it out and storing the next 20 years in a
table



--
Nick
-----We Solve your Computer Problems---
UNIX, C, Panther, Ingres, Interbase, Firebird - Available Shortly

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Robin Davis
Sent: 26 April 2006 19:05
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Caculating specific dates for each year


Hi,

This is where I show just how little I know!

In the UK our tax year is 2006/05/01 to 2007/04/30 etc etc. I've been
able to work out how to do yearly reports by manually entering the start
and end dates into a query, but is it possible to use Firebird's brain
to recognize the start and end date of a new tax year so the creation of
new reports can be automatic? i.e. When the clock rolls over from 30th
April, 2006 to 1st May, 2006, the DB recognizes the fact and starts a
new tax year block of analysis.

Guess who's trying to save himself trouble changing the dates for the
last six tax years to reflect the new tax year? ;-)

Rob Davis


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]