Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
So far I have the following set analysis, but I need the second condition to be >=1, but <=7.
At the moment I only have >=1 as I don't know how to add in "and <=7" without it creating an error.
The set analysis I have so far is as follows:
= If((([MaxExpiryDate]-(Today()))>= 1),'1-7 days','+ 7 days'))
How do I write the condition so MaxExpiryDate is greater than or equal to 1, but less than or equal to 7, please?
Many thanks