hi all,
i have this data at mytable when i run the select statment i get empty select,
i need to brows all contracts need one month to finished or it allready finshid
edate have dates as..
sdate=02/04/2007 edate=02/04/2008
sdate=07/09/2007 edate=07/09/2008
sdate=01/01/2007 edate=01/01/2008
sdate=03/03/2007 edate=02/03/2008
SELECT * FROM mstr WHERE between (DATE(),GOMONTH(edate,-1),edate)
thanks
> > hi all,
> >
> > i need help to display all contracts from mytable before one month end contact,