MATLAB Answers

How to convert this 'out_17-May-2021.xlsx' into 'out_20210517.xlsx'?

1 view (last 30 days)
Dear all,
How to convert this (below) into 'out_20210517'?
filename = sprintf('out_%s.xlsx', today('datetime'));
filename =

Accepted Answer

Geoff Hayes
Geoff Hayes on 17 May 2021
Joanna - perhaps try using
Siddharth Bhutiya
Siddharth Bhutiya on 19 May 2021
You could also do it using datetime by specifying the display format using the Format name-value pair.
>> filename = sprintf('out_%s.xlsx', datetime('now','Format','yyyyMMdd'))
filename =
This seems like a simple workflow so it might not matter, but if you are working with dates and times, datetime would be recommended over using something like datestr or datenum.

Sign in to comment.

More Answers (1)

VBBV on 17 May 2021
%if true
k = datestr(filename(5:15),'yyyymmdd')
You can use filename to reconstruct the date



Community Treasure Hunt

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

Start Hunting!

Translated by