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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. not2techie

    Precise 2 month daterange

    You might try an if/then if datediff ("m", {?Start Date},{?End Date}) <= 2 then datediff("m", {?Start Date},{?End Date}) depending on what you what to happen with the ones over 2 you can put that in the else.
  2. not2techie

    Counting records within a date range

    That was my first inclination. However, what would you group by? If I group by opened day I miss the items that were opened the previous/next day. Can you group by a variable? How do I set it up? Can you group by a calendar month? again. I've never used variables. thanks much
  3. not2techie

    Counting records within a date range

    Thanks Yes. I am trying to create a work in progress. I was hoping that I wouldn't have to create 30 counts( one count for every day of the month). Ex: The output should be 1/10/06 # inprogress = 1 1/11/06 # inprogress = 1 1/12/06 # in progress = 1 1/13/06 # in progress = 1 1/14/06 # in...
  4. not2techie

    Counting records within a date range

    Hello! I am a fairly new Crystal user. I am trying to roll up data and see items in progress for a particular date range. Q: How many items are in progress on 1/10, 1/12, 1/14, total for the month etc. If they are opened and not closed, they are in progress. Data: Item # Opened Date...

Part and Inventory Search

Back
Top