Change Date Formatting for Excel in Matlab

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

Answer 1

[Pratyush Swain]

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));

10-Dec-2024 10:58:49

For more information on 'datetime' function, please refer to https://www.mathworks.com/help/matlab/ref/datetime.html

Hope this helps.

[Devidutta]

Thanks, This was really helpful!