Results 1 to 3 of 3

Thread: Date Parameter

  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Unanswered: Date Parameter

    Hi everybody! I desperately need help with this.
    We currently have a crystal report that we need to run every Mondays, Wednesdays, and Fridays. Well, we got Cview so it could run the queries and email them automatically. The problem now is how do we set the date on the report to run for that particular day?

    Example: Let say that it’s Monday 09/18/06

    Mondays report needs to run with the following date in the criteria:
    09/16/06
    Wednesday report needs to run with the following date in the criteria:
    09/19/06
    Friday report needs to run with the following date in the criteria:
    09/21/06

  2. #2
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    I haven't used CR for a long time, but I'm pretty sure there is a dayofweek function to return what todays day is, and from that you can determine the daterange for your report.

    Sunday = 1, Monday =2, .... Saturday = 7.

    so (if DayOfWeek(Today) = 2 then (Today)-2)
    (if DayOfWeek(Today) = 4 then (Today)-1)
    (if DayOfWeek(Today) = 5 then (Today)-1)


    09/16/06
    09/19/06
    09/21/06

  3. #3
    Join Date
    Sep 2006
    Posts
    2
    Hi,
    I need a little more help. I did find the dayoftheweek function but I am not how to use it.
    So let me give you more details. The filed that we want to change the date on is SFAAPPC.

    So when dayoftheweek = Mondays or Wednesday or Friday, I want the report to run with SFAAPPC =DATE -1day. I am to sure how to set it up correctly using Formula Editor on Crystal; Reports.
    Ov7

Posting Permissions

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