View License

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Highlights from
Date Vector/Number to ISO 8601 Date String

5.0 | 1 rating Rate this file 5 Downloads (last 30 days) File Size: 6.27 KB File ID: #34095 Version: 1.17
image thumbnail

Date Vector/Number to ISO 8601 Date String



06 Dec 2011 (Updated )

Convert a Date Vector/Number to an ISO 8601 Date String. Tokens control the date/time notation.

| Watch this File

File Information

Easy conversion of a date vector or a serial date number into a date string. The date string may be an ISO 8601 timestamp or a single date/time value, selected by (optional) input token/s. Multiple tokens may be used to output multiple strings.

The ISO 8601 timestamp style options supported by this function are:
* Date in calendar, ordinal or week-numbering notation.
* Basic or extended format.
* Choice of date-time separator character.
* Full or lower precision (fewer trailing date/time units).
* Decimal fraction of the trailing unit (decimal places).

By default the function uses the current time and returns the basic ISO 8601 calendar timestamp: this is very useful for naming files that sort alphabetically into chronological order!

### Examples ###

Examples use the date+time described by the vector [1999,1,3,15,6,48.0568].

 ans = '19990103T150648'

 ans = '1999003_1506'

 ans = '1999-01-03T15:06:48'

[D1,D3] = datestr8601(now-2,'D','DDD')
 D1 = '5'
 D3 = 'Fri'

 ans = 'Sunday 3rd January 1999'

[ddd,YWD,mmyy] = datestr8601([],'ddd','*YWD','mmmm','yyyy');
sprintf('The %s of %s has the ISO week-date "%s".',ddd,mmyy,YWD)
 ans = 'The 3rd of January 1999 has the ISO week-date "1998-W53-7".'

### ISO 8601 Date Notations ###

Timestamps are shown here in extended format with the default date-time separator character 'T'.

1) Calendar:
string: '1999-01-03T15:06:48'
token: '*ymdHMS'

2) Ordinal:
string: '1999-003T15:06:48'
token: '*ynHMS'

3) Week-numbering:
string: '1998-W53-7T15:06:48'
token: '*YWDHMS'

### Single Value Strings ###

* One date/time value per output string (note: can be concatenated afterwards).
* Consistent token syntax.
* Easily adapted to other languages.
* Single Values include: day of the year or days remaining in year; year quarter (3-month or 13-week); year; month as digit or name; day of week as digit or name; date of month; hour; minute; second; deci/centi/milliseconds.


Number To Scientific Prefix, Customizable Natural Order Sort, Round Serial Date Numbers Or Date Vectors, Iso 8601 Date String To Serial Date Number, Time Str, Number To Words, Natural Order Row Sort, and Natural Order Filename Sort inspired this file.

This file inspired Iso 8601 Date String To Serial Date Number, Round Serial Date Numbers Or Date Vectors, Number To Myriad, Number To Words, Words To Number, Natural Order Row Sort, Natural Order Filename Sort, and Customizable Natural Order Sort.

Required Products MATLAB
MATLAB release MATLAB 7.11 (R2010b)
MATLAB Search Path
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (1)
26 Jun 2014 Long

Long (view profile)

Thanks a lot. A very useful subroutine.

06 Dec 2011 1.2

Some corrections to Description field and Mfile help comments.

08 Dec 2011 1.3

Added Ordinal Date style, and format control.

04 Jan 2012 1.4

- Now accepts Date Number OR Date Vector.
- Now accepts multiple input Tokens (to provide multiple output Strings).
- Add 13-week year-quarter token.
- Improve help documentation.

06 Jan 2012 1.5

Add default time (current time).
Add default token 'BymdHMS'.
Add ordinal date with suffix, eg '3rd'.

13 Feb 2012 1.6

- Add day-of-week (as a number) and year (week-date) tokens.
- Examples that better illustrate the ISO 8601 week date.
- Change token syntax (for consistency with calendar / week-date year-type).

24 Aug 2012 1.7

- Help improved to better contrast calendar vs week-numbering dates.
- Remove basic format prefix 'B', and add extended format prefix '*' (logical, easier to read and search for).
- Test function string can be displayed directly in command window.

10 Dec 2012 1.8

- Fix bug in Midnight/AM/Noon/PM calculation.
- More examples.

18 Dec 2012 1.9

- Allow 'F' (millisecond) in 8601 timestamp tokens.

25 Feb 2013 1.11

ISO 8601 dates/timestamps:
- Allow decimal fraction of any trailing unit (decimal places).
- Allow choice of any date-time separator character.

11 Mar 2013 1.12

- Disallow period '.' as date-time separator character.

24 Jun 2013 1.13

- Removed 'F' from ISO 8601 timestamps: please use decimal fraction instead.
- Complete list of date-time separator exclusions.
- Improve examples.
- Simpler Midnight/AM/Noon/PM calculation.

10 Mar 2014 1.14

- Improve token input checking and error messages.
- Restrict date-time separator character to ' ','T','@','_'.
- Add ordinals for Day of Year (required token format change).

07 Aug 2014 1.15

- Remove calendar week number (confusing!)

03 Nov 2014 1.16

- Downloadable as toolbox

01 Jan 2015 1.17

* Update online blurb.
* Add concatenation of remaining strings into last output (if more tokens than outputs).

Contact us