DateToNumber

Description

Given a Date/Time value, returns that date encoded as a numeric value of the type used by slots to containing date/time values.

Type

NUMERIC

Arguments

Type

Meaning

1

DATETIME

The date/time value to encode as a numeric value.

Comments

Slots representing date/time values have unit type DateTime.

The date/time value need not be fully specified, but the return value should only be assigned to a slot with appropriate units. For example, if the value @"January 1" should only be assigned to a slot with units "MonthAndDay".

 
DateToNumber(@"t")
 
6508706400.00 - which is equivalent to "06:00 April 3, 2006" (FullDateTime)
 

This function should be used in conjunction with dates on series slots and the NumberToDate function See NumberToDate. A specific use example is shown .