>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
In this example:
1. What is date()? (Make sure your computer clock has the correct date!)
2. What is the date format? You can get this with
? set("date")
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)