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:
25.12.1973
or
25.12.73
or the time in the form 23:59:59
;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 and time functions are shown below:
AGE(date1, date2)
Works out the difference between two dates in years and months. date1 should be the more recent date, and date2 the earlier date.
For example:
AGE(26.6.1994, 25.8.1982)
returns the age as a number, expressed as 12.10, that is, someone aged 12 years and 10 months.
Use INT() to extract the number of years from the result and 100*(n-INT(n)) to extract the number of months.
DATE(year, month, day)
Builds a date from individual components.
For example,
DATE(61,3,17)
returns 17.03.1961
.
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(date)
Returns the days component of date.
For example,
DAY(17.3.61)
returns 17
.
DAYNAME(number|date)
Returns a day name string corresponding to the number or date (where Sunday is day one).
HOUR(time)
Returns the hours component of time.
For example,
HOUR(18:33:04)
returns 18
.
MINUTE(time)
Returns the minutes component of time.
For example,
MINUTE(18:33:04)
returns 33
.
MONTH(date)
Returns the months component of date.
For example,
MONTH (2.9.91)
returns 9
MONTHDAYS(date)
Returns the number of days in the month of date.
For example,
MONTHDAYS(1.2.84)
returns 29
.
MONTHNAME(number|date)
Returns a month name string corresponding to the number or date (where January is month one).
NOW
Returns today's date and time, in the form 2.9.1991
18:33:04
.
SECOND(time)
Returns the seconds component of time.
For example,
SECOND(18:33:04)
returns 4.
TIME(hour, minute, second)
Builds a time from individual components.
For example,
TIME(18,33,04)
returns 18:33:04
.
TIMEVALUE(text)
Converts text to a time.
For example,
TIMEVALUE("18:33")
returns 18:33:00
.
TODAY
Returns today's date, in the form 2.9.1991
.
WEEKDAY(date)
Returns the weekday of date, where Sunday is 1.
For example,
WEEKDAY(17.3.61)
returns 6
(Friday).
WEEKNUMBER(date)
Returns the week number corresponding to the date.
YEAR(date)
Returns the years component of date.
For example,
YEAR(15.3.1066)
returns 1066
.
For information on | See |
---|---|
@D@ | Text @-fields |