6 Replies Latest reply: Mar 30, 2013 4:32 PM by Bradley Coyne RSS

    Daystart Function -  time field

    Bradley Coyne

      Hi.

       

      Goal: Calculate all open tickets for a time intervall between 17:00 yesterday and 17:00 today;

      (2) create this time intervall as one time field as "Today".

       

       

      What i am assuming would be best is to use the daystart function. Here is the Pseudologic i am aiming to achieve.

       

      open = date ticket was opened.

       

      if  Date(Daystart(open > 17:00 (yesterday) & <17:00 (today)) = "Today".

       

      is there anyone who has used this function for this purpose?

       

       

      Best

      Bradley