0
$\begingroup$

Is it possible to convert dates, like e.g.

date = "2018-02-15";

to be represented by whole number increments starting with 30 December 1899, midnight UTC? I believe this is called DATE format in Windows. Maybe there is an internal Mathematica function that does this?

Improve this question
$\endgroup$
3
  • $\begingroup$ hoe about DateObject[{2018, 02, 15}] $\endgroup$
    – ZaMoC
    Commented Oct 18, 2018 at 14:48
  • $\begingroup$ @J42161217 Sorry, this does not return an integer number of days since 30 December 1899... $\endgroup$
    – Kagaratsch
    Commented Oct 18, 2018 at 14:52
  • 3
    $\begingroup$ You could simply use AbsoluteTime[<date>] or DayCount["12/30/1899", "02/15/2018"] $\endgroup$
    – user42582
    Commented Oct 18, 2018 at 15:01

2 Answers 2

Reset to default
4
$\begingroup$

Easiest way to avoid the units system would be something like

(AbsoluteTime["2018-02-15"] - AbsoluteTime["1899-12-30"])/86400

(untested, as I am on gedanken Mathematica)

Improve this answer
$\endgroup$
0
$\begingroup$

So far I have hacked together the following:

QuantityMagnitude[
  DateDifference[{1899, 12, 30, 0, 0, 0.`}, 
   DateList[ date ]]] // Round

43146

Can this be made quicker, to be used with large sets of dates efficiently?

Improve this answer
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.