I'm looking for help on Calculated Field Functions, I've looked through the knowledge base but the examples there don't help very much. Previous experience of creating nested If and Case statements in Excel along with building a database in FileMaker.
I have two date fields "Start" and "End", which may or may not be blank. I want to build a function expression that mirrors the statements below:
If "Start" = blank/empty/null etc., display "Start date to be confirmed"
If "Start" > Today, display "Inactive"
If "Start" <= Today AND "End" = blank/empty/null etc., display "Active"
If "Start" <= Today AND "End" < Today, display "Ended"
Any help with the above would be really appreciated, many thanks...