Get previous month's records from current date.  Going back 12 months.

Trygve Thayer
Trygve Thayer used Ask the Experts™
on
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.ShipHead.ShipDate} >=dateserial(year(currentdate), month(currentdate) ,1) and
{TGC_Ship__Summary.ShipHead.ShipDate} < dateserial(year(currentdate), month(currentdate)+1 ,1)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
{TGC_Ship__Summary.ShipHead.ShipDate} >=dateserial(year(currentdate), month(currentdate)-1 ,1) and
{TGC_Ship__Summary.ShipHead.ShipDate} < dateserial(year(currentdate), month(currentdate) ,1)

Open in new window

Trygve ThayerIT Director

Author

Commented:
Thanks !  New it was something simple.  Just could not get the right syntax.
Trygve ThayerIT Director

Author

Commented:
Thanks for helping me Kimputer !!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial