Problem with "datenum" and "datetime" functions

5 views (last 30 days)
I need to extract date information from a formated date string. I have used both datenum and datetime functions but both of them returned an error. However, when I run the code on a different computer it worked well. Here is the simple code and the corresponding error:
Example for DATENUM:
datenum('11/02/2005 13:10:00','dd/mm/yyyy HH:MM:SS')
datenum('11/02/2005 13:10:00','dd/mm/yyyy HH:MM:SS')
Error: Invalid text character. Check for unsupported symbol,
invisible character, or pasting of non-ASCII characters.
Example for DATETIME:
datetime('11/02/2005 13:10:00','InputFormat','dd/MM/yyyy HH:mm:ss')
datetime('11.02.2005 13:10:00','InputFormat','dd.MM.yyyy HH:mm:ss')
Error: Invalid text character. Check for unsupported symbol,
invisible character, or pasting of non-ASCII characters.
Why don't the functions work on my computer?
  3 Comments
Shubhra S
Shubhra S on 8 Sep 2021
Edited: Shubhra S on 8 Sep 2021
I am also facing a similar error.The function works on one pc and doesn't work on another

Sign in to comment.

Accepted Answer

Sean de Wolski
Sean de Wolski on 29 Apr 2019
I was able to reproduce this by copying your code from above. It appears the opening ( is bad (right where the arrow is)
datetime('11/02/2005 13:10:00','InputFormat','dd/MM/yyyy HH:mm:ss')
Deleting your ( and replacing with my ( fixed it.
Further investigating it looks like there is an invisible character after the (
int32('(')
ans =
1×2 int32 row vector
40 65279
  1 Comment
Peter Valent
Peter Valent on 30 Apr 2019
I have addet the following check, which solved the problem.
textToConvert = '11/02/2005 13:10:00';
acceptedCharacters = int32([' ','.','/',int32(arrayfun(@num2str,0:9)),':']);
textToConvert = textToConvert(ismember(int32(textToConvert),acceptedCharacters));
datenum(textToConvert,'dd/mm/yyyy HH:MM:SS')

Sign in to comment.

More Answers (0)

Categories

Find more on Dates and Time in Help Center and File Exchange

Products


Release

R2018b

Community Treasure Hunt

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

Start Hunting!