Results 1 to 8 of 8

Thread: business days

  1. #1
    Join Date
    Oct 2011
    Posts
    8

    Unanswered: business days

    hi
    i have a problem in writing a formula...

    i should getcount of members scheduled for an interview within 10 business days...(bussiness days means monday to saturday inclusive)

    "Plz help
    thank you...

  2. #2
    Join Date
    Oct 2010
    Posts
    46
    It would really help if you would post:

    fields you want to use to calculate
    formula that you have written
    the error you are getting

    In any case, you have posted this 3 times asking for help on the same topic and yet failed to try it out yourself.

    To test the dates for 10 business days, you need to use the DateDiff function:

    Code:
    DateDiff
    
    DateDiff returns a number of time intervals between two specified dates
    
    Syntax:
    
    DateDiff (intervalType, startDateTime, endDateTime) 
    DateDiff (intervalType, startDateTime, endDateTime, firstDayOfWeek) 
    
     intervalType is a String expression that is the interval of time you use to calculate the difference between startDateTime and endDateTime.
     startDateTime is the first DateTime value used in calculating the difference. 
     endDateTime is the second DateTime value used in calculating the difference. 
     firstDayOfWeek is an optional constant specifying the first day of the week. 
    
    Returns
    A Number value

  3. #3
    Join Date
    Oct 2011
    Posts
    8
    hi i want

    interview date with in next 10 bussiness days


    the column is interview date

    business days mns no sundays....

  4. #4
    Join Date
    Oct 2010
    Posts
    46
    hi you get

    the function is datediff

    the date is interview date

    the intervaltype is d

  5. #5
    Join Date
    Oct 2011
    Posts
    8
    hi thanks for the reply,...

    but i should not include sunday in those bussiness days....

  6. #6
    Join Date
    Oct 2011
    Posts
    8

    hello

    hi

    thank you again


    i want the formula even with no holidays inluded in the formula.....

    the actuall question is:
    (2) Count the members with a printed associated initial visit Care Plan (initial print only, never a reprint) with in 10 bussiness days...
    (3) Determine the difference in time (Days, hrs and mins) between the member's IA appointment completion and the time the associated initial visit Initial Care Plan was printed



    interview is the column...
    please help...

  7. #7
    Join Date
    Sep 2011
    Posts
    20
    Quote Originally Posted by pavansap View Post
    please help...

    Please post your codes..

    Example:
    Code:
    Whileprintingrecords; 
      Numbervar one; Numbervar two; Numbervar three; Numbervar four; 
      if {Orders.Order Amount} < 1000 then  one else  two;

  8. #8
    Join Date
    Oct 2011
    Posts
    3
    Welcome back!Wish you were here every moment a lot of fun





    ___________________
    silkroad gold
    sro gold
    silkroad online gold

Posting Permissions

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