Dear Shavinder Singh,

I did learn in the same as you, missing a lot first. Dont give up. My suggestion is to put this variable on the .QES that would be automatically calculate during entry.

Usually the formula is LET variable_age=ROUND(INT((now_date - birth_date)/365.25))

Epidata does not round and transform the calculation automatically and this syntax is necessary every time you will do any calculation with dates.

Good luck, Pedro Emmanuel Brasil

2007/2/20, epidata-list-request@lists.umanitoba.ca < epidata-list-request@lists.umanitoba.ca>:

Send EpiData-list mailing list submissions to epidata-list@lists.umanitoba.ca

To subscribe or unsubscribe via the World Wide Web, visit http://lists.umanitoba.ca/mailman/listinfo/epidata-list or, via email, send a message with subject or body 'help' to epidata-list-request@lists.umanitoba.ca

You can reach the person managing the list at epidata-list-owner@lists.umanitoba.ca

When replying, please edit your Subject line so it is more specific than "Re: Contents of EpiData-list digest..."

EpiData-list mailing list ___________________________________

Today's Topics:

1. Date range selection for age calculation (epidata-list@lists.umanitoba.ca)

---

Message: 1 Date: 20 Feb 2007 07:15:30 -0000 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Date range selection for age calculation To: epidata-list-request@lists.umanitoba.ca Cc: epidata-list@lists.umanitoba.ca Message-ID: 20070220071530.19938.qmail@webmail35.rediffmail.com Content-Type: text/plain; charset=iso-8859-1

Dear Epidata team friends, I have two American date format variables. DOB is date of birth of baby and WDATE is date of weighing the baby for the growth monitoring.

I used to write the following statement to calculate the age in months in EPI6

Define age ### Let age=(WDATE – DOB)/30.44

That does not work in EPI ANALYSIS

I tried the statement; Let age= (date("WDATE","mdy") - date("DOB","mdy"))/30.44 The error message was; Data type mismatch

Please help.

Shavinder Singh

---

---

EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list

End of EpiData-list Digest, Vol 40, Issue 15

---