In SPSS, how can I calculate the number of days between two variables in Date format?

In SPSS, to calculate the number of days between two variables in Date format, consider the following example:

Suppose you have two variables, formatted as date1 = mm/dd/yyyy and date2 = mm/dd/yyyy. To calculate the number of days between date1 and date2, use the following SPSS code:

A new variable (days) will be created, which holds the number of days between date1 and date2. If the date in date1 is after the date in date2, the value in the variable days will be a negative number.

Note: You can format variables using other date formats defined in SPSS (e.g., mm/dd/yy [12/31/99], dd.mm.yyyy [31.12.1999], dd-mm-yyyy [31-DEC-1999]).

For more about statistical and mathematical software, email the UITS Stat/Math Center, visit the center's web page, or phone 812-855-4724 (IUB) or 317-278-4740 (IUPUI). The center is located in Bloomington at 410 N. Park Avenue, and is open for consultation by appointment Monday-Friday 9am-5pm.

Comments/Questions/Corrections