2 Replies Latest reply: Mar 21, 2017 12:02 PM by Stefan Wühl RSS

    How do I get a 'between' expression to work?

    Louisa Sizeland

      Hi there,

       

      I need to create an IF statement that contains a 'between' expression but I cant seem to get it to work. Basically I have a formula which is working out the no. of months since a booking date to now and I need it to only show me the entries have a No. of months since booking date between 9 and 12 months.

       

      The formula I have to give me the no. of months is as follows,

      ((year(today(2))*12)+month(today(2))) - (((year([BookingDate.autoCalendar.Date])*12)+month([BookingDate.autoCalendar.Date])))

       

      Can anyone help?

       

      Thank you!