1 Reply Latest reply on Aug 10, 2015 11:38 AM by philmodjunk

    Need to extract starting en ending hour

    Sidney

      Title

      Need to extract starting en ending hour

      Post

      I hav a list of events on different dates and different timings 

      I Would like to extract the first and last time "starting / ending  hour" of the first / last  day " starting / ending  day" out of a list of dates (events)

      Is there an easy way to do this?

        • 1. Re: Need to extract starting en ending hour
          philmodjunk

          Sounds like you need a field of type timestamp that combines both the date and the time in the same field. This can be a calculation field that uses your date and time fields to calculate a timestamp value. (See the TimeStamp function for an easy way to use a time field and a date field to produce such a value.)

          You could then sort these records by this time stamp field in order to access the start and end times and dates for such a list of events.