Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Change YearToDate start Date
- Thread starter dido
- Start date
synapsevampire
Programmer
Easy enough to write your own:
In the record selection criteria use:
{MyTable.MyDateField} >= cdate("01/03/2002"
This assumes that the date field would not contain any dates beyond today, if it does:
({MyTable.MyDateField} >= cdate("01/03/2002"
and
{MyTable.MyDateField} <= currentdate)
-k kai@informeddatadecisions.com
In the record selection criteria use:
{MyTable.MyDateField} >= cdate("01/03/2002"
This assumes that the date field would not contain any dates beyond today, if it does:
({MyTable.MyDateField} >= cdate("01/03/2002"
and
{MyTable.MyDateField} <= currentdate)
-k kai@informeddatadecisions.com
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question