2 Replies Latest reply: Mar 20, 2015 8:59 AM by Annika Palm RSS

    Span between two date fields

    Annika Palm



      I have a table for items that have FROM dates and TO dates,

      per item these FROM and TO can be overlaped and come in chains. there are several FROM and TO dates per item. 


      In this case i want to establish he lenght between FOM and TOM, and se which ones that have a span longer than 30 days. So no gaps in the series of dates. and if one FROM date is equal to a previous TO date this is a chain and also needs to be counted for when it comes to number of days.


      i rather this to be in the script but anything will do!