Date Formula

[ccnetwork]

Hi

I have a database table that contains dates for the last 3 years. I know its possible to find out the period 1 from date for 2007 using a running total but is it possible to find out the value using a formula ?


Database Table
------------------
Year Period SetID DateFrom DateTo
2007 1 SE 01/04/2007 04/05/2007
2007 2 SE 05/05/2007 01/06/2007
2007 3 SE 02/06/2007 29/06/2007
2007 4 SE 30/06/2007 03/08/2007
2007 5 SE 04/08/2007 31/08/2007
2007 6 SE 01/09/2007 28/09/2007
2007 7 SE 29/09/2007 02/11/2007
2007 8 SE 03/11/2007 30/11/2007
2007 9 SE 01/12/2007 28/12/2007
2007 10 SE 29/12/2007 01/02/2008
2007 11 SE 02/02/2008 29/02/2008
2007 12 SE 01/03/2008 31/03/2008

 

[Madawc]

You could do a summary total on DateFrom, get the minimum, which ought to be the Period 1 date. Does this help?

If not, what is it you are after? Why isn't it OK to use a running total?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10