Oct 21, 2004 #1 herd Technical User Jun 23, 2003 46 US To look at data for the past 2 years in a querry, would the expression look like this >Date()-720?
Oct 21, 2004 #3 RickSpr MIS Jan 4, 2001 2,885 US Actually, 730 (365 * 2) would be more accurate. Or, for the greatest accuracy possible, use >DateAdd("yyyy", -2, Now()) Rick Sprague Want the best answers? See faq181-2886 To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein Upvote 0 Downvote
Actually, 730 (365 * 2) would be more accurate. Or, for the greatest accuracy possible, use >DateAdd("yyyy", -2, Now()) Rick Sprague Want the best answers? See faq181-2886 To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein