How do I add a time column in the format of YYYY-MM-DD to my table?

Saunok Chakrabarty · Apr 11, 2023 · 2K views
Question
I have a table containing time series data of some macroeconomic variables. My data is quarterly, starting from 1947-01-01 and ending on 2022-10-01. However, MATLAB is representing these dates numerically - eg, 1947-01-01 shows up as -725846400, after I imported the file into MATLAB from R. How do I change the time column to quarterly data in the range that I want?
Expert Answer
Profile picture of John Williams
John Williams PhD Expert
Answered Aug 24, 2026
I think R stores dates as posix time.
You can use something like this to convert to datetime format eg 31-Dec-1969 23:59:56
d = datetime(-725846400, 'ConvertFrom', 'posixtime')

 

100% Run Guarantee 3-Hour Fast-Track Delivery

Need a Custom Version or Complete Simulation for This Problem?

Our 500+ PhD engineers build, debug, and optimize working MATLAB scripts and Simulink (.slx) models tailored to your exact assignment rubrics with zero plagiarism.

Tested on MATLAB R2024b / R2026a
Turnitin 0% Plagiarism Report
Free 7-Day Revisions Guarantee
Have a different question? Ask here

Get a Free Consultation or a Sample Assignment Review!