1 Reply Latest reply: May 15, 2014 10:15 AM by scrtchmstj _ RSS

    Converting Date to Excel Format

    scrtchmstj _

      I've added a calculated field to one of my models that subtracts one date field from another. I just learned that the calculation is not returning the same number as it does in Excel and I found out it has to do with a difference in how Excel formats dates vs how Monarch professional formats them. Excel formats them as the number of days since Jan 00, 1900. So the date 03/31/13 in Excel is actually the value 41274 (days). I'm not sure how Monarch formats dates. Is there a way to format dates in Monarch the way Excel formats them?