next up previous contents index
Next: 4.6.1 Using Date Functions Up: 4 Entering Data Previous: 4.5.2 Changing the Numeric

4.6 Entering Dates and Times

   

If you entered a date or time as a string of numbers separated by hyphens, 10-31-91 for example, NExS would interpret this string as a formula and display the result in the cell as -112.

To tell NExS to interpret the entry as a date or time, begin the entry by typing a slash (/) before the desired value. Type a / followed by the date or time in the formats mm/dd/yy, dd.mm.yy, dd-mmm-yy, yyyy-mm-dd, and hh:mm:ss. The dates and times entered with this method are converted to the equivalent references to @DATE and @TIME. For example:

Date/Time Entered as: Generates:
19 July 1990 /07/19/1990 =@DATE(90,7,19)
6 April 1966 /6.4.66 =@DATE(66,4,6)
27 September /27-sep-91 =@DATE(91,9,27)
24 March 1954 /1954-3-24 =@DATE(54,3,24)
12:30 /12:30 =@TIME(12,30,0)


If the year (yy) is omitted when entering a date into a cell, the current year is assumed. For example, entering /7/17 is equivalent to entering /7/17/95 if the current year is 1995.




next up previous contents index
Next: 4.6.1 Using Date Functions Up: 4 Entering Data Previous: 4.5.2 Changing the Numeric

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999