Dates and Times

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

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

You can specify whether you want to use English-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 click Select on American for American-style dates, English for English-style dates or Text for textual dates (the default).

3. Type the date into a number slot as day.month.year for English-style dates or month.day.year for American-style dates.

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

You can test whether two slots 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 functions are shown below:

DATE

DATE(year,month,day)

Builds a date from individual components.

For example,

DATE(61,3,17)

returns 17.03.1961.

DATEVALUE

DATEVALUE (text)

Converts text to a date.

For example,

DATEVALUE("17.3.61")

returns 17.3.1961.

text can also include a time.

For example,

DATEVALUE("17.3.61 17:15")

returns 17.3.1961 17:15.

DAY

DAY(date)

Returns the days component of date.

For example,

DAY(17.3.61)

returns 17.

HOUR

HOUR(time)

Returns the hours component of time.

For example,

HOUR(18:33:04)

returns 18.

MINUTE

MINUTE(time)

Returns the minutes component of time.

For example,

MINUTE(18:33:04)

returns 33.

MONTH

MONTH(date)

Returns the months component of date.

For example,

MONTH (2.9.91)

returns 9

MONTHDAYS

MONTHDAYS(date)

Returns the number of days in the month of date.

For example,

MONTHDAYS(1.2.84)

returns 29.

NOW

NOW

Returns today's date and time, in the form 2.9.1991 18:33:04.

SECOND

SECOND(time)

Returns the seconds component of time.

For example,

SECOND(18:33:04)

returns 4.

TIME

TIME(hour,minute,second)

Builds a time from individual components.

For example,

TIME(18,33,04)

returns 18:33:04.

TIMEVALUE

TIMEVALUE(text)

Converts text to a time.

For example,

TIMEVALUE("18:33")

returns 18:33:00.

TODAY

TODAY

Returns today's date, in the form 2.9.1991.

WEEKDAY

WEEKDAY(date)

Returns the weekday of date, where Sunday is 1.

For example,

WEEKDAY(17.3.61)

returns 6 (Friday).

YEAR

YEAR(date)

Returns the years component of date.

For example,

YEAR(15.3.1066)

returns 1066.

For information on See
@D@ Text @-fields