Trygve Thayer
asked on
Get previous month's records from current date. Going back 12 months.
How do I get this to show all the records in the previous month? This works to show all the records in the current month.
{TGC_Ship__Summary.ShipHea d.ShipDate } >=dateserial(year(currentd ate), month(currentdate) ,1) and
{TGC_Ship__Summary.ShipHea d.ShipDate } < dateserial(year(currentdat e), month(currentdate)+1 ,1)
{TGC_Ship__Summary.ShipHea
{TGC_Ship__Summary.ShipHea
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for helping me Kimputer !!!
ASKER