Julian day to date

18 vues (au cours des 30 derniers jours)
Daphne PARLIARI
Daphne PARLIARI le 29 Août 2020
Hello everyone.
I have a simple (hopefuly) question. In the attached excel file, column C contains year and column D the day of year (e.g. 01/01/2007 is day 1 and 31/12/2007 is day 365).
Is there a way to convert this date type into the format dd-mm-year, with each of the three numbers in separate columns (one for the day, one for the month and one for the year)?
Thank you in advance!

Réponses (1)

the cyclist
the cyclist le 29 Août 2020
Modifié(e) : the cyclist le 29 Août 2020
Here is one way:
dateTable = readtable('KALAMARIA_2007.xlsx','Range','C:D');
julianDate = datetime(dateTable.YEAR,1,dateTable.JULIANDAY);
julianY = year(julianDate);
julianM = month(julianDate);
julianD = day(julianDate);
Of course, you don't really need to calculate the Julian year again, since it is already available as an input, but I made it for consistency.
  1 commentaire
Med Aymane Ahajjam
Med Aymane Ahajjam le 31 Jan 2023
THANK YOU!

Connectez-vous pour commenter.

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by