Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2013
    Posts
    1

    Unanswered: Crystal reports current date formula

    Crystal reports current date-1 as my organisation used 1 day old data for current report and use friday data for monday report.

    As per current report it shows Calls answered =1 if it is 1 in the DB but if I have full month dates in DB it shows all the dates.

    2 fields I am using from DB are :
    1. Group 1 Call start time , Ascending order , each day.
    2. Summarized Agent name, Count , grand total : count agent name

    1 Formula
    datediff ("s", {Sheet1_.Call Start Time},{Sheet1_.Call End Time})

    Current date for .xls database is 1 day before and for monday means last friday.

    Please help
    Attached Thumbnails Attached Thumbnails calls_ans.jpg  

Tags for this Thread

Posting Permissions

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