Returns anumber
value from the given {0}. If the given {0} isnull
,Number.From
returnsnull
. If the given {0} isnumber
, {0} is returned. Values of the following types can be converted to anumber
value:
text
: Anumber
value from textual representation. Common text formats are handled ("15", "3,423.10", "5.0E-10"). SeeNumber.FromText
for details.logical
: 1 fortrue
, 0 forfalse
.datetime
: A double-precision floating-point number that contains an OLE Automation date equivalent.datetimezone
: A double-precision floating-point number that contains an OLE Automation date equivalent of the local date and time of {0}.date
: A double-precision floating-point number that contains an OLE Automation date equivalent.time
: Expressed in fractional days.duration
: Expressed in whole and fractional days.
Returns a number from 1 to 4 indicating which quarter of the year the date {0} falls in. {0} can be a date , datetime , or ...
Returns a number from 1 to 5 indicating which week of the year month the date {0} falls in. {0}: A datetime value for which ...
Returns a number from 1 to 54 indicating which week of the year the date, {0}, falls in. {0}: A datetime value for which ...
Returns a number value from the given text value, {0}. {0}: The textual representation of a number value. The representation ...
Returns a number value from the given {0}. If the given {0} is null , Number.From returns null . If the given {0} is number ...
Returns a one column table that contains the distinct (unique) values in a column, for a column argument. Or multiple columns ...
Returns a profile for the columns in {0}. The following information is returned for each column (when applicable): minimum ...
Returns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation. ...
Returns a record after applying transformations specified in list {1} to {0}. One or more fields may be transformed at a ...