3 Replies Latest reply: Apr 3, 2013 12:38 PM by Faisal Zahid RSS

    get the first and last day of a month in a specific year

    Ali Hijazi

      Hello

      I have the following task to be implemented

      I have an excel sheet in which each employee has the date and time on which the (s)he came into the office and left

      I want to calculate the total number of hours each employee spent in the office per month and display this info on a chart

      what I'm thinking of is calculate the number of hours per day then get the total group by month

      so what I need here is to know the first day and the last day of a month specified by the user from an input object so that I know the range of date to calculate the total number of hours ; plus I appreciate if you supply me with date and time functions