Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    2

    Unanswered: Last 180 days report

    Hello everyone,

    I need to create a crystal report where the date written was in the last 180 days. Any ideas?

    Thanks!

  2. #2
    Join Date
    Feb 2009
    Posts
    10
    If you mean, include only data within the last 180 days, then in your record selection criteria add:

    date_written >= dateadd("dd", currentday, -180)

    I might not have that "dateadd" command formatted properly, so double-check that.

    David

  3. #3
    Join Date
    Jan 2009
    Posts
    2
    That worked! Thank you so much!

  4. #4
    Join Date
    Feb 2009
    Posts
    10

    Re:

    You're very welcome!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •