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 biv343 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: *

  • Users: STCPD
  • Order by date
  1. STCPD

    formula for date range prior to date search parameter

    I figured it out! Thanks! I changed my record selection to: {lwmain.date_rept}>={@STARTFORMULA} AND {lwmain.date_rept}<={?END DATE} And I created a formula(@STARTFORMULA): DATEADD("D",-DATEDIFF("D",{?START DATE},{?END DATE}),{?START DATE}) Then in my running total evaluate I used...
  2. STCPD

    formula for date range prior to date search parameter

    In the running total, I'm summarizing lwcharg.ucr_code as a count. In the evalute section I have tried these formulas. {lwmain.date_rept} >= dateadd("d", -datediff("d",{?START DATE}, {?END DATE}), {?START DATE}) and {lwmain.date_rept} <= {?END DATE}; {lwchrg.ucr_code}="220" AND {lwmain.zone}...
  3. STCPD

    formula for date range prior to date search parameter

    Thanks for your help but apparently I'm going to need someone to spell it out for me. I've spent days trying to get this to work and I think I'm about to throw in the towel! I've only been working with Crystal the last month so I'm easily confused:(
  4. STCPD

    formula for date range prior to date search parameter

    I'm sorry I'm new to Crystals. I don't know what you mean by two running totals. Is this all going to go into the running total field I created?
  5. STCPD

    formula for date range prior to date search parameter

    Maybe I'm not doing something right but it didn't seem to work. I used {lwmain.date_rept} >= dateadd("d", -datediff("d",{?START DATE}, {?END DATE}), {?START DATE}) and {lwmain.date_rept} <= {?END DATE}; {lwchrg.ucr_code}="23F" AND {lwmain.zone} IN ["Z1","Z2","Z3","Z4","Z5","Z6","Z7","Z8"] in...
  6. STCPD

    formula for date range prior to date search parameter

    I'm working on a formula to calculate the number of criminal offenses that occurred in the same amount of days as my date search parameter but prior to the start date. The date search parameter is always changing. The idea is to compare the number of offenses from the last time period. For...

Part and Inventory Search

Back
Top