Dates and Times

PipeDream has a set of date and time functions which enable you to build dates and times in number cells and do calculations with them.

You can enter dates and times in one of three ways:

You can specify whether you want to use British-style dates, American-style dates or textual dates.

  1. Bring up the Options dialogue box.
  2. Position the pointer on the Date format line and select M.D.Y for American-style dates, D.M.Y for British-style dates or Text for textual dates (the default).
  3. Type the date into a number cell as day.month.year for British-style dates or month.day.year for American-style dates.

The text @-field @D@ inserts the current date into a text cell in the format selected in the Options dialogue box.

You can test whether two cells contain the same date with a statement such as:

IF(B1=A1,...)

You can tell whether one date is later than another with a statement such as:

IF(A1>B1,...)

The date and time functions are listed in the next section.

For information on See
@D@ Text @-fields