Hello, all from a wet and windy, Blighty.
I am being so dense today and now have spaghetti for brains.
I have a date field (SaleDate) and a calculation field (SaleTerm)
Whichever way I write a Case statement I can't get to populate the (SaleTerm) with the correct value.
If the SalesDate is 01 Sept 2016 to 31 Dec 2016 inclusive SaleTerm should be "Term 1"
01 Jan 17 to 31 March 17 "Term 2"
01 April 17 to 31 July 17 "Term 3"
I know it's going to be so easy, but my head is in a right pickle now I have tried a multitude of permutations!
Can anyone help?
Thanks in advance Guys and Gals