For time calculations (such as the number of days between two dates) proper date variables are needed. In some cases, the digits of a numeric variable may represent year, month and day. This tutorial shows how to convert this format into an actual date variable.<\/p>\n\n\n
In some cases, dates are represented as numeric variables whose digits represent a year, month and day (often referred to as YYYY-MM-DD). This format is not suitable for any time based calculations which require an actual date variables<\/a>. The solution for this is to convert the original variable into an actual date variable. This is demonstrated by the syntax<\/a> below.<\/p>\n\n\n For time calculations (such as the number of days between two dates) proper date variables are needed. In some cases, the digits of a numeric variable may represent year, month and day. This tutorial shows how to convert this format into an actual date variable.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[82],"tags":[],"class_list":["post-199","post","type-post","status-publish","format-standard","hentry","category-spss-date-conversions"],"_links":{"self":[{"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/posts\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/comments?post=199"}],"version-history":[{"count":0,"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/posts\/199\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/media?parent=199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/categories?post=199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spss-tutorials.com\/wp-json\/wp\/v2\/tags?post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}SPSS Date Function Syntax Example<\/h2>\n\n
<\/strong>
data list free\/date(f8).
begin data
20111030
end data.
*2. Convert into date format.
<\/strong>
compute realdate = date.dmy(mod(date,10**2),tru(mod(date,10**4)\/10**2),tru(date\/10**4)).
format realdate(edate10).
exe.<\/div>\n \nSPSS Date Function Explanation<\/h2>\n\n
\n
DATE.DMY<\/code> calculates this number.<\/li>\n FORMAT<\/code> is set (for example) to EDATE10<\/code>.<\/li>\n TRUNCATE<\/code> and MODULUS<\/code>.<\/li>\n DATE.DMY<\/code> function.<\/li>\n DATE.DMY<\/code> as is done here.<\/li>\n<\/ul>\n\n\n\n\n","protected":false},"excerpt":{"rendered":"