This content has been marked as final. Show 2 replies
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?