AnsweredAssumed Answered

Finds Using Elapsed Time

Question asked by Annette on Dec 17, 2013
Latest reply on Dec 23, 2013 by Annette

Title

Finds Using Elapsed Time

Post

     I have a calculation that returns an elapsed time between two dates in months and days which works just as i want it to.  But the problem is when I'm trying to do a find.  If I wanted to find a record where the elapsed time is between 0 months 0 days and 4 months 0 days how do I got about this?  I will need to do various finds for the following: 

     0 - 4 months 0 days

     4 months 1 day - 8 months

     8 months 1 day - 12 months

     12 months 1 day - 18 months

     18 months 1 day - 24 months

      

     Thanks!! 

Outcomes