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!

Selecting records NOT in lastfullmonth

Status
Not open for further replies.

campbmb

Technical User
Apr 26, 2007
18
US
Hi I'm using version XI. I am sure this is a simple thing, but I'm in a hurry and can't find it anywhere. I am trying to write a formula in the Selection Expert to suppress the GF when {datefield} is NOT in the lastfullmonth. How do you write the opposite of "{datefield} in lastfullmonth"? Thanks in advance!
 
Okay... like I said, I figured it was something easy. Nevermind!

not({datefield} in lastfullmonth)

Just couldn't figure out where to put that NOT for a while!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top