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!

Recent content by DudleyBoy

  1. DudleyBoy

    Crystal Report Formula

    Hi, Could someone help me with modifying this formula. if {message_stats.msg_transmission_date} >= DATEADD ("m", -12, CURRENTDATE-day(currentdate))+1 and {message_stats.msg_transmission_date} < maximum(lastfullmonth) + 1 then {message_stats.msg_premium} This returns a value if the date is...
  2. DudleyBoy

    Last Full Month in Last Year

    Thanks. I've removed the }, the date field is also substituted, it's now refering to this part and saying a date is needed dateadd("yyyy",-1, currentdate); Any thoughts?
  3. DudleyBoy

    Last Full Month in Last Year

    Hi, I know I'm missing something basic with this: datevar x := dateadd("yyyy",-1, currentdate});{table.date} in dateadd("m",-1,x-day(x)+1) to x-day(x) but I keep gettin gthe error that the ")" is missing, where's it missing from? Any Ideas?
  4. DudleyBoy

    Last Full Month in Last Year

    Hi, I was wondering if someone could help. I need to have a formula that gives results for the last full month, but for last year. So if i were to run the report today 18th May 2010 it would return results for All April 2009. Thanks All
  5. DudleyBoy

    Rolling Twelve Months - Whole Months Only

    Thanks for this explanation. I really appreciate it. I understand now what its doing.
  6. DudleyBoy

    Rolling Twelve Months - Whole Months Only

    Thanks for this, it does exactly what I need it to. Can you help me one stage further and explain what the formula is actually doing? Thanks again.
  7. DudleyBoy

    Rolling Twelve Months - Whole Months Only

    HI, I'm new to crystal and Tek-tips so any help would be really aprreciated. I need to create a formula/paramter using a date field for a rolling 12 months but for whole months only. So, if I run the report today, 9th December, it will only report on dates that are 30th November 2009 back to...
See more

Part and Inventory Search

Back
Top