Change Date Formatting for Excel in Matlab
3 次查看(过去 30 天)
显示 更早的评论
Hi community,
I am working on script to read from file and save to Excel, currently have dates in form of '10/12/2024; 10:58:49'.
I want to use the datestr function to get it in a readable way like '10-Dec-2024 10:58:49'
Can someone help me in this ? I am using MATLAB R2024a
Thanks
0 个评论
采纳的回答
Pratyush Swain
2025-1-3
编辑:Pratyush Swain
2025-1-3
Hi Devidutta,
The 'datestr' function is not recommended to be used since R2022b as mentioned here: https://www.mathworks.com/help/matlab/ref/datetime.datestr.html
Alternatively you can use this following approach to acheive your desired date & time format:
% Original date string, separated by semicolon
dateStr = '10/12/2024; 10:58:49';
% Convert to datetime
dt = datetime(dateStr, 'InputFormat', 'dd/MM/yyyy; HH:mm:ss');
% Format the date using the datetime display format
dt.Format = 'dd-MMM-yyyy HH:mm:ss';
% Display the result
disp(char(dt));
For more information on 'datetime' function, please refer to https://www.mathworks.com/help/matlab/ref/datetime.html
Hope this helps.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!