How to Create Date Variables in Displayr

This article describes different methods for converting variables into Date/Time variables. 

Note: Many of the issues that previously required these conversion methods have now been resolved. If your goal is to customize the order in which time periods appear in tables, renaming labels, hiding or merging periods, or creating NETs, you no longer need to convert your variable first. See How to Configure a Date/Time Variable > Customize the labels and categories of your Date/Time variable.

For files with metadata, like .sav files, if the variable has a type of Date/Time, it will have a Date/Time structure in Displayr. For other date files without metadata (e.g., in Excel files), Displayr will initially treat these dates as categories or text, and they must be converted manually to a Date/Time structure. There are a number of approaches to make them usable as Dates.

• Method 1 - Changing the Variable Type
• Method 2 - Converting with R Code
• Method 3 - Encoding using Year, Month and Day with JavaScript
• Method 4 - Converting from the YYYYMMDDHHMMSS or YYYY.MM format
• Method 5 - Converting with JavaScript functions
• Method 6 - Reading dates from Value Labels

Requirements

• A Data Source with a variable you want to convert.

Method 1 - Changing the Variable Type

The most straightforward way to create a date variable is to change a variable's Data > Attributes > Structure to Date/Time in Properties . Displayr will automatically insert a new Date/Time variable underneath, and you will receive an error if Displayr can't detect the date format correctly to convert (i.e., mm/dd/yyyy and dd/mm/yyyy are both detected automatically).

In situations where Displayr cannot work out the date correctly, you will need to use one of the other methods below.

Method 2 - Converting with R Code

1. Select any variable in the Data Sources tree and click + > Custom Code > R > Date/Time.
2. Type in the code flipTime::AsDateTime(datevar) in the Code panel, replacing datevar with the name of the variable that contains the dates.
3. Optional: The above code works on the most common date formats, but not all. If that code doesn't work for you, then you may need to use Method 6 - Reading dates from Value Labels below.

Method 3 - Encoding using Year, Month, and Day with JavaScript

Displayr contains two special functions for computing dates given knowledge of year (y), month (m), etc.

• Q.EncodeDate(yyyy, mm, dd)
• Q.EncodeDateTime(yyyy, mm, dd, hh, mm, ss, ms)

This is useful if you have individual variables for the month, day, and year, etc, of the date. If you have a wave variable, you can also use these functions to assign each wave a date. For example, see: How to Create a Date Variable from a Categorical Variable Using JavaScript.

Method 4 - Converting from the YYYYMMDDHHMMSS or YYYY.MM format

The following are all examples of the date and time format YYYYMMDDHHMMSS: 20060929205137, 20060929184343, 20060929161711, 20060929160305, 20060929211356, 20060929190754, and 20060929190948, which are all from the 29th of September 2006. Where the variable v1 is a Text Variable in this format, the following Expression will convert it into a numeric JavaScript Variable:

Math.floor(Q.AsNumeric(v1)/1000000) - 20060000;

Alternatively, to turn this date into year and month (YYYY.MM), use:

Math.floor(Q.AsNumeric(LastResp)/100000000)/100;

Method 5 - Converting with JavaScript functions

Where x is the name of your Text Variable:

• Q.AsDate(x) Converts strings into dates. Accepts a variety of formats, but expects dd/mm/yy when in doubt.
• Q.AsDateUS(x) Converts strings into dates. Accepts a variety of formats, but expects mm/dd/yy when in doubt.
• Q.AsDateISO Converts strings into dates. Accepts a variety of formats, but expects yy-mm-dd when in doubt.

Directly computing the date

Displayr represents dates with the number of milliseconds since 1970, and expressions can be written in JavaScript, which converts data to this format. Care should be taken to address date anomalies (e.g., leap years) and differences in time zones.

Other numeric date formats exist:

Method 6 - Reading dates from Value Labels

If you have a date in a more custom format, you will need to specify the format in either custom JavaScript or R variable.

• JavaScript: Where the value labels contain the date strings, Q.Label(x) can be used (e.g., Q.AsDate(Q.Label(x))) when creating a JavaScript Variable. 
• R: Use the strptime() function and provide the specific format, similar to:
  strptime(datevar, format = "%B %d, %Y") 
  you can find how to specify the format of the date based on the documentation here.

If your dates are ambiguous (don't include a month, day, or year), you will need to manually provide a month/day of the date. That is, if your variable labels are "March 2014", you may assume in the code that the day of the month is the 1st with strptime(paste0(datevar, "-1"), format = "%B %Y-1") to be able to peg that label to a specific day on the timeline. Note that you can still use Aggregate in the Date/Time Aggregation settings to aggregate the dates to 1 Month to show the monthly labels again, see How to Configure a Date/Time Variable.

Next

How to Configure a Date/Time Variable

How to Calculate the Difference Between Two Dates

How to Create a Date Filter on an Output