I have this calculation...
= IF(AND(Time Submitted >= DATE(2013, 03, 25), Session = "Afternoon (Middle/Senior)"), "RESERVE ONLY")
..and it works perfectly. Any submissions after the 25th March 2013 for the Afternoon session are labelled as RESERVE ONLY.
when I open the form this column is blank. If I click on the calulcation and, without editing it, hit return to 'enter it' again it pops back to life and does its thing... perfectly. Until I close the form again.
Thanks for your feedback. I will follow up this issue with engineering team.
Are you still experiencing this problem? If so, are you able to share the form with me so that I can investigate further? My own, local, tests have been unable to reproduce the problem.
Well darn it!
Things moved on - the application time ended and I deleted the column when I set up a separate reserve list.
I've just tried to re-create the problem and can't...
Sorry... sod's law I believe!