<< Click to Display Table of Contents >> Navigation:  Dashboard Designer > Data Shaping > Formatting Data > Formatting Date-Time Values

 

Formatting Date-Time Values

To specify a format for date-time values, use the Format submenu in the data item menu.

This submenu lists the available format types that depend on the selected group interval (for details on group intervals, see Grouping).

 

The following list shows format types by group interval.

Full - The full year pattern (Example - 6/15/2017 1:45:30 PM -> 2017 (en-US)).

Abbreviated - The year from 00 to 99 (Example - 6/15/2017 1:45:30 PM -> 17 (en-US)).

Full - The full quarter pattern (Example: 6/15/2017 1:45:30 PM -> Q2 (en-US)).

Numeric - The quarter from 1 through 4 (Example: 6/15/2017 1:45:30 PM -> 2 (en-US)).

Full - The full name of the month (Example: 6/15/2017 1:45:30 PM -> June (en-US)).

Abbreviated - The abbreviated name of the month (Example: 6/15/2017 1:45:30 PM -> Jun (en-US)).

Numeric - The month from 1 through 12 (Example: 6/15/2017 1:45:30 PM -> 6 (en-US)).

Long - Long hour pattern, 12-hour format (Example: 6/15/2017 1:45:30 PM -> 1:00 PM).

Short - Short hour pattern, 24-hour format (Example: 6/15/2017 1:45:30 PM -> 13).

Day of Week

Full - The full name of the day of the week (Example: 6/15/2017 1:45:30 PM -> Monday (en-US)).

Abbreviated - The abbreviated name of the day of the week (Example: 6/15/2017 1:45:30 PM -> Mon (en-US)).

Numeric - The day of the week from 1 through 7 (Example: 6/15/2017 1:45:30 PM -> 2 (en-US)).

Day-Month-Year

Long - Long date pattern (Example: 6/15/2017 1:45:30 PM -> Monday, June 15, 2017 (en-US)).

Short - Short date pattern (Example: 6/15/2017 1:45:30 PM -> 6/15/2017 (en-US)).

Date-Hour

Long - Long date pattern, long hour pattern (Example: 6/15/2017 1:45:30 PM -> Monday, June 15, 2017 1:00 PM (enUS)).

Short - Short date pattern, long hour pattern (Example: 6/15/2017 1:45:30 PM -> 6/15/2017 1:00 PM (en-US)).

Time only - Long hour pattern (Example: 6/15/2017 1:45:30 PM -> 1:00 PM (en-US)).

Date-Hour-Minute

Long - Long date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> Monday, June 15, 2017 1:45 PM (enUS)).

Short - Short date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> 6/15/2017 1:45 PM (en-US)).

Time only - Long time pattern (Example: 6/15/2017 1:45:30 PM -> 1:45 PM (en-US)).

Date-Hour-Minute-Second

Long - Long date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> Monday, June 15, 2017 1:45:30 PM (en-US)).

Short - Short date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> 6/15/2017 1:45:30 PM (en-US)).

Time only - Long time pattern (Example: 6/15/2017 1:45:30 PM -> 1:45:30 PM (en-US)).

The list below illustrates format types related to the Exact Date group interval.

Full - The full year pattern (Example: 6/15/2017 1:45:30 PM -> 2017 (en-US)).

Abbreviated - The year from 00 to 99 (Example: 6/15/2017 1:45:30 PM -> 17 (en-US)).

n/a - The default year and full quarter pattern (Example: 6/15/2017 1:45:30 PM -> Q2 2017 (en-US)).

n/a - The default year pattern and the full name of the month (Example: 6/15/2017 1:45:30 PM -> June, 2017 (enUS)).

Long - Long date pattern (Example: 6/15/2017 1:45:30 PM -> Monday, June 15, 2017 (en-US)).

Short - Short date pattern (Example: 6/15/2017 1:45:30 PM -> 6/15/2017 (en-US)).

Long - Long date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> Monday, June 15, 2017 1:00 PM (enUS)).

Short - Short date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> 6/15/2017 1:00 PM (en-US)).

Time only - Long time pattern (Example: 6/15/2017 1:45:30 PM -> 1:00 PM (en-US)).

Long - Long date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> Monday, June 15, 2017 1:45 PM (enUS)).

Short - Short date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> 6/15/2017 1:45 PM (en-US)).

Time only - Long time pattern (Example: 6/15/2017 1:45:30 PM -> 1:45 PM (en-US)).

Long - Long date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> Monday, June 15, 2017 1:45:30 PM (en-US)).

Short - Short date pattern, long time pattern (Example: 6/15/2017 1:45:30 PM -> 6/15/2017 1:45:30 PM (en-US)).

Time only - Long time pattern (Example: 6/15/2017 1:45:30 PM -> 1:45:30 PM (en-US)).