Clear Filters
Clear Filters

No InputFormat 'YYMMDD' found for datetime

4 views (last 30 days)
Is there a way to transform '240331' into '31 March 2024' ?
The following does not work:
datetime('240331',InputFormat,'YYMMDD')
Unrecognized function or variable 'InputFormat'.
  2 Comments
Stephen23
Stephen23 on 2 May 2024
Edited: Stephen23 on 2 May 2024
"No InputFormat 'YYMMDD' found for datetime"
Character case matters!
"Is there a way to transform '240331' into '31 March 2024' ?"
datetime('240331', 'InputFormat','yyMMdd', 'Format','dd MMMM yyyy')
ans = datetime
31 March 2024

Sign in to comment.

Accepted Answer

Steven Lord
Steven Lord on 2 May 2024
Either leave the quotes off but use == (if you're using a sufficiently recent release) or add quotes. You will need to adjust your format specifier, though.
datetime('240331',InputFormat = 'yyMMdd')
ans = datetime
31-Mar-2024
datetime('240331','InputFormat','yyMMdd')
ans = datetime
31-Mar-2024
You need to use 'yy' instead of 'YY' and 'dd' instead of 'DD'.
datetime('240331',InputFormat = 'YYMMDD')
Error using datetime (line 669)
The format 'YYMMDD' contains an unsupported symbol: 'Y'. See the datetime.Format property for a complete description of the identifiers used in datetime formats.
  3 Comments
Steven Lord
Steven Lord on 2 May 2024
Since the format needs to have ways to represent both the Month component and the minute component of a datetime, the most natural representation IMO is for M to be case sensitive. [This was not a choice MathWorks made; that's part of the Unicode Locale Data Markup Language specification linked from the documentation page I reference below. I believe the LDML uses the symbols from ISO standard 8601.]
The table in the entry for the Format property on the datetime documentation page lists the character and character sequences that have special meanings when used in a format specifier (either the InputFormat name-value argument to the constructor or the Format property which can be set in the constructor or after the object has been created.)
Sim
Sim on 2 May 2024
Wow, nice explanation, thanks! I will read about the document page :-)

Sign in to comment.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!