Re: [GENERAL] How to find first non-vacation day

2006-02-03 Thread Chris Browne
"Andrus Moor" <[EMAIL PROTECTED]> writes: > I have a table of vacations > > create table vacation ( > id integer primary key, > dstart date, > dend date ); > > > I need to find first non-vacation day before given date. > > This can be done using the following procedural vfp code > > function nonva

Re: [GENERAL] How to find first non-vacation day

2006-02-03 Thread Chris Browne
[EMAIL PROTECTED] (Philip Hallstrom) writes: >>> I have a table of vacations >>> create table vacation ( >>> id integer primary key, >>> dstart date, >>> dend date ); >>> I need to find first non-vacation day before given date. >>> This can be done using the following procedural vfp code >>> funct

Re: [GENERAL] How to find first non-vacation day

2006-02-03 Thread Philip Hallstrom
I have a table of vacations create table vacation ( id integer primary key, dstart date, dend date ); I need to find first non-vacation day before given date. This can be done using the following procedural vfp code function nonvacation( dbefore ) for i=dbefore to date(1960,1,1) step -1 se

Re: [GENERAL] How to find first non-vacation day

2006-02-03 Thread Philip Hallstrom
I have a table of vacations create table vacation ( id integer primary key, dstart date, dend date ); I need to find first non-vacation day before given date. This can be done using the following procedural vfp code function nonvacation( dbefore ) for i=dbefore to date(1960,1,1) step -1 se