Hidden Values Tutorial Part 2: Calculations Using a Date

Hidden Values Example 2: Calculate Using a Date

A common calculation is to take the date of the Last Menstrual Period (LMP) and calculate the Estimated Date of Delivery (EDD).
In general terms, the way we do this is by taking the date of LMP and adding approximately 9 months to it.

In CommCare terms, we want to take the value of the question "Date of Last Menstrual Period" and add 274 days (9 months + 1 week) to it. The resulting date is the EDD!

Let's try it out!

• Create a new hidden value by clicking on the 'Add Question' followed by Hidden Value from the question tree.

• Change the Question ID to "edd"

• Click on "Edit" next to the Calculate Condition box

• Drag the question "Date of Last Menstrual Period" over to the Expression Editor (Advanced) box until you see the green check mark, and then release

• Write a "+" because we want to add something to this date

• Type "274." Your total expression should look like this:

Open

• At the beginning of the expression write date and then put parentheses around the expression like this: 
  
  

Open

The reason you have to write date first and then put the parentheses around the expression is that when you add an integer number to the question lmp, the result is by default stored as a string, not as a date. We have to "cast" it as a date by putting date first and then parentheses around the expression. Otherwise it will just look like a long number!

• Hit "Save" and you will be ready to go!

In the next part of the tutorial you will learn how to write an "if" statement.

Go to the next part