- In the provided code, it is unclear what the first parameter passed to datetime() i.e. s contains. Ensure that it complies with the valid input arguments for datetime()
- Ensure that the data in the spreadsheet has dates in the correct format. You can use readtable() to get data from the excel sheet. You can refer to the following answer for further details regarding it: https://www.mathworks.com/matlabcentral/answers/577180-how-to-use-datetime-datestr
- Specify the input format in datetime()
- To display the date in the figure, you can pass the value returned by datetime() to datestr() as follows:
Unable to change the date in .fig
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi , i use this below code and not able to change the date from Dec 31 1899. .Fig image is attached.I would like to change the date from Dec 31 1899 to 17 Feb 2020
Please help .i am getting this error when i try to change the date in edit .fig .
Unable to convert 'Feb' to datetime using the format 'MMM dd, u, HH:mm'. If the date/time text contains day, month, or time zone names in a language foreign to the 'en_US' locale, those might not be recognized. You can specify a different locale using the 'Locale' parameter
clc
y=xlsread('time.xlsx');
plugin=y((1:end),8)';
outd = datetime(s,plugin, 'convertfrom', 'excel');
figure
plot(outd)
0 Kommentare
Antworten (1)
Gargi Patil
am 12 Apr. 2021
I understand that you would like to display dates read from an excel file.
You can try the following:
t = datetime('now','TimeZone','local','Format','d-MMM-y');
datestr(t,'dd mmm yyyy');
You can use the following documentations as reference:
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!