Date Calculation

[Kitty]

Hi,

Please help with date calculation. I am new to FileMaker and appreciate your input.

If visit = Prescreen, then Deadline_Date = Received_Date + 1 week.

Please note, the user will enter a received date and the program should calculate the deadline date.

If visit = HSCT 35 or HSCT 42 or HSCT 49 then Deadline_Date = 12/1/2008.

I have attached the filemaker file and really appreciate your help on how to write a script or calculation to perform these 2 scenarios. thank you.

Patients.zip

[The Shadow]

Here you go.

I changed your "Received_Date" to be of type "Date". Being of type date allows date math to work properly, so adding 7 moves you forward one week (FileMaker automatically understands moving over months, if this year is a leap year, etc.)

The Case() calculation function let's you choose between different possibilities and provide different results.

Patients.fp7.zip