Drexel dragonThe Math ForumDonate to the Math Forum

Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.

Math Forum » Discussions » Software » comp.soft-sys.math.mathematica

Topic: hold question
Replies: 1   Last Post: Feb 11, 2014 2:24 AM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View  

Posts: 122
Registered: 1/29/05
Re: hold question
Posted: Feb 11, 2014 2:24 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply


Please look into a book on Calendrical Calculations by Edward Reingold,
Nachum Dershowitz

Some versions of their book also contains Mathematica code.

The following link is an excerpt see section 1.2 "Fixed Day Numbers"

(Google Books [
_ge_summary_r&cad=0#v=onepage&q&f=false ])

The book can be overkill for such just solving your issues; but you stated
that".. dates is always a pain ... in any language.."

Most computational language systems that I am aware of, when relating to
date time, use a similar method of fixing the date and time to a number.

A properly formatted date and/or time cell (or column) in Excel is really a
serialized date time in the back ground. So if you are always going to be
importing date columns in Excel you may choose to import the serialized


-----Original Message-----
From: Francisco Gutierrez [mailto:fgutiers2002@yahoo.com]
Sent: Monday, February 10, 2014 2:01 AM
Subject: hold question

Dear Group:

Manipulating and importing/exporting dates is always a pain in the neck, in
any of the languages I am aware of.
Mathematica has functions to work around many of these issues, and I was
actually able to complete the task I was involved in, but even then there is
an issue I obviously do not understand.

Say I have this date in an Excel sheet: 01/08/2007. I import in into
Mathematica. I want to prevent it from becoming an arithmetical expression,
so I sorround it by Unevaluated, HoldAll, and other hold-like devices, but I
do not obtain the desired result. The date becomes a division.
For example, the output of HoldComplete[2+2] is HoldComplete[2+2] , but
instead the output of HoldComplete[ 01/08/2007] is HoldComplete[1/(8x

What I am overlooking?
(Mathematica 9.0)

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© The Math Forum 1994-2015. All Rights Reserved.