convert dates to specific format
4 views (last 30 days)
Show older comments
how can I change the format of the dates in the column shown in the image to the format uuuuMMddHHmm?
Answers (2)
Stephen23
on 19 Jul 2022
Edited: Stephen23
on 19 Jul 2022
My guess is that you have unfortunately stored each date as one numeric value, whose digits just happen to coincide with the date units' digits. This is rather a misuse of numerics, and is best fixed by importing that data correctly, rather than trying to "fix" it later. But you can convert to a proper DATETIME object if required:
N = 200701022359 % ugh
D = datetime(string(N),'Format','uuuuMMddHHmm')
Checking:
D.Year
D.Day
D.Minute
Note that you should avoid deprecated functions DATENUM, DATESTR, and DATEVEC.
0 Comments
KSSV
on 19 Jul 2022
t0 = datenum(today) % probably you have datenums
t1 = datetime(datestr(t0)) % convert them to datetime
t1.Format % check the format
t1.Format = 'uuuuMMddHHmm' % change the format
3 Comments
Stephen23
on 19 Jul 2022
"Any advice how to fix it?"
- understand how your date is currently stored.
- use that knowledge to select a suitable tool to convert it to DATETIME.
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!