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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
LAST 2 MONTHS FORMULA 2
- Thread starter Nmartin95
- Start date
-
1
- #2
-
1
- #3
synapsevampire
Programmer
Or if you want just the data within the last 2 months as opposed to the last 60 days of data:
{datefield} >= dateadd("m", -1, date(year(currentdate), month(currentdate),1))
This would return all data from 5/1/2002 based on a June run date. Adjust the -1 to however many months back you need.
-k kai@informeddatadecisions.com
{datefield} >= dateadd("m", -1, date(year(currentdate), month(currentdate),1))
This would return all data from 5/1/2002 based on a June run date. Adjust the -1 to however many months back you need.
-k kai@informeddatadecisions.com
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question