Date Sequencer

Home Up Odds & Ends Photo Gallery Search Contact Me

 

 

The information in this website is provided without risk or obligation and free of charge.  However, if you have benefitted from my efforts here and would like to make a contribution to help me continue and maintain this work then any donation will be greatly appreciated. Please click the adjacent button to access PayPal.  Thank you.
 
Date Sequencer, now with a time span calculator, is intended as a manually loaded Word Add-In.  It provides a user interface for inserting a current, past, or future date, and extended date sequence entries in Word documents. The time span calculator will display the time span between two anchored date values with a choice of two formats.  You can use "Date Sequencer" to insert the current date, a "picked" date from a calendar control, roll up/back (i.e., future or past) dates, and user defined date sequences.  The Add-In is provided at the bottom of this page in a zip file format. You can download "Date Sequencer" to your Word Templates directory and load it using Tools>Templates and Add-Ins. For more on Add-Ins and how to load them, see the heading "Organizing Global Templates" at:    Organizing Your Macros

User interface with "Date Sequencer" is through an easy to use toolbar and Control Panel.

The Control Panel depicted above shows the default values.  The panel opens with the current date and time displayed.  Pressing the "OK" button will insert the current date at the insertion point. 
    - Use the Start/Anchor Date & Time sub-panel to "pick" any date/time for insertion, as a reference point for roll back/roll up dates, as a starting point for sequences and to anchor span ranges. 

    - The Period sub-panel defines the roll back/up and sequence period.

    - The Factor sub-panel defines the step value of the period (e.g., 1 minute, 5 months,  30 days, etc.)

    - The Number sub-panel is used for the sequence applications only.  It defines the number of steps in the sequence.

    - The Display Format sub-panel provides most standard date/time display formats.  Users can set any of the pre-defined or their favorite custom format (in any logical date/time format) as the default.   

  

     - The Output sub-panel contains six output options
        * Sequenced AutoText.  The information panel below is taken from the "Date Sequencer" Welcome screen.  Inserting AutoText generating sequenced date values is helpful when preparing itineraries, planners, schedules, etc.  

        * Text.  The output option for inserting the current date, picked dates, and roll back/up dates.  "Text" option can also be used to generate and display a plain text sequence.
        * Fill selected cells.  Lets you select cells and fill with a sequence.  In the sample below, the first row of cells was selected.  The Start date is any "Sunday," the period setting is "Day," the factor setting "x1," and the Date Format setting "dddd."

       ... or just as easily select a long column of cells and apply a schedule sequence.  In this example, the user would pick cells in the left hand column.  The start time is 08:00, the period is minute, the factor is 15, and the display is hh:mm.

        * Roll Back/Up.  This is a handy options for quickly computing and entering past of future dates.
        * Span/periods.  Use of the time span calculator is explained in the "Welcome" screen text.
If you would like to give "Date Sequencer" a try, you can down load it in Zip format from the link below.   I would like to acknowledge the support and assistance of several regular Word newsgroup contributors in creating this Add-In:  Doug Robbins, Jonathan West, Jay Freedman, Helmut Weber, Andi Mayer,  Klaus Linke, and Jezebel.  Thank you gentlemen for sharing your outstanding talents.
Apparently the Calendar Control in Word2003 is not compatible with Word2000.  I am a providing links to  a Date Sequencer Add-In with Calendar Control 9.0 and Date Sequencer Add-In with Calendar Control 11.0.  I am not sure if Word97 or Word2002 will work with either version as I don't have those platforms to test with.

 Download DateSequencer(9.0)                                                                                   Download DateSequencer(11.0)

 


Looking for something else?

Google