IF, PERHAPS CASE....
Who can guide me then?
I have an orders table, within that table I have a ValidFrom (Date) and Expires (Date)
I would like to see when at any given occasion that I run a find, another calculated cValidToday field would show "Valid" or "invalid". I've had a dabble with a nested if but to no avail, I can't get my head around it!!
ValidFrom | Expires | cValidToday
01 Jun 2011 | 30 June 2011 | Valid
16 Jun 2011 | 04 July 2011 | Invalid
01 Jun 2011 | 14 June 2011 | Invalid
A solution would be a very welcome Birthday gift !!! ;@)