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 derfloh 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. nickloe

    Trying to strip out year

    Thank you very much! Worked as needed. Nick
  2. nickloe

    Trying to strip out year

    Thank you so much for your help, that worked great! Not to be a pain, but how would I use this same formula to only pull YeartoDate for each of the years? In other words, Aug 31, 2008 and Aug 31, 2009 and Aug 31, 2010? Thanks!!
  3. nickloe

    Trying to strip out year

    Hello, I am trying to create a formula field using Crystal Syntax that will evaluate three years of sales and just SUM sales from a specific year. I can't get it to work! I have tried... Sum ({OPPORTUNITY.ACTUALAMOUNT}, {OPPORTUNITY.DATECLOSED}) Can anyone help? Thanks!!
  4. nickloe

    Simple "IF" Formula Won't Work

    Worked like a charm!! Thank you so much. Nick
  5. nickloe

    Simple "IF" Formula Won't Work

    Hello, I am trying to evaluate a field in my database that "contains" a certain word. I can't seem to get this to work... there is no function for "contains"... I tried if {HISTORY.DESCRIPTION} like "estimates" then "True" Any ideas? Thanks so much!!
  6. nickloe

    Calculate what week of the year it is

    In one of my reports I need to base a calculation on what week it is of the year. For example, Feb 9 - 13 is the 6th full week of the year. Does anyone know how to get this calculation? Thanks!! Nick

Part and Inventory Search

Back
Top