Skip to main content
R
RichardJ19-Tanzanite
19-Tanzanite
October 3, 2010
Question

Date Calendar and Time functions.mcd

  • October 3, 2010
  • 21 replies
  • 13744 views

Here is a selection of functions for dates, calendars, and times. Also included is a calendar component that allows a date to be selected by the user. The scripted components were all written by me, but the additional functions at the end of the worksheet were not. In fact, I don't know who did write some of them, but if the author of those functions, or someone who knows who the author is, reads this then please let me know who did write them so I can credit them correctly.

Jun 09 2015: Added a worksheet for Mathcad Prime. This includes only the limited set of functions not based on scripted components.

    21 replies

    Show previous replies
    M
    MikeArmstrong1-Visitor
    1-Visitor
    October 5, 2010

    I'm not going mad.........Am I?????

    Think Ziyad removed it

    Mike

    R
    RichardJ19-TanzaniteAuthor
    19-Tanzanite
    October 5, 2010

    i think if just a time is given it should be assumed to be current date rather than dec 1899

    I don't much care for that behavior either, but I'm just hijacking a VBscipt function, and that's the way it works. The only way I could fix it would be to do a fair amount of string handling or regular expression matching to trap the case when there is only a time. Too much work. Sorry.

    M
    MySchizoBuddy1-Visitor
    1-Visitor
    October 5, 2010

    thats fine Richard. I don't want to impose a hard solution for a small problem.

    you have already helped me alot with date stuff.

    Thank you

    M
    MySchizoBuddy1-Visitor
    1-Visitor
    October 11, 2010

    Did you get time to change SplitDate function to be able to use a vector of dates

    R
    RichardJ19-TanzaniteAuthor
    19-Tanzanite
    October 11, 2010

    Did you get time to change SplitDate function to be able to use a vector of dates

    Sorrry, not yet. It turned into a very busy weekend. I will try and get to it tomorrow.

    R
    RichardJ19-TanzaniteAuthor
    19-Tanzanite
    October 12, 2010

    OK, I have uploaded a new version of the document. SplitDate and AssembleDate now handle multiple dates at one time.

    For completeness, I also added the functions form here:

    http://communities.ptc.com/docs/DOC-1431

    to the end of the document.

    R
    RonaldEJohnson1-Visitor
    1-Visitor
    March 24, 2011

    Very helpful.  Thanks

    S
    StuartBruff23-Emerald V
    23-Emerald V
    May 4, 2011

    Neat.  Good work.

    R
    RichardJ19-TanzaniteAuthor
    19-Tanzanite
    May 4, 2011

    Neat.  Good work.

    Thanks. I just felt my head swell slightly

    T
    Tezza20101-Visitor
    1-Visitor
    May 6, 2011

    Richard,

    Your worksheet on dates does show where some of the functions came from.  One Terry Hendicott who does not claim creation but lists the book that they came from.  They are a translation from C++ functions in the reference.

    Glad to see contributions are reused - refined and upgraded.

    Cheers.

    Show more replies
    Terms & ConditionsAccessibility statement