todays(X;Y)

Convert a string, months, or days value to a floating-point days interval. (Available as of version 15.19)

Syntax

todays(X;Y)

Input

Argument Type Description
X text A scalar value or the name of a column containing a time interval
Valid values can be of the form:
  • string
  • months
  • days
Y text Reserved for future use

Return Value

Returns an floating-point value representing the number of days and/or partial days. This value can then be added to a date or date+time value.

For more information about date formats, see Dates and time.

If the input values are not in one of the supported formats listed above, the function returns an erroneous or illogical output.

Example

The following example converts a period of time into a days interval.

<table cols="time_interval">
"1.5 weeks"
"2.3 years"
"10.2 weeks"
"3.5 months" 
</table>

<willbe name="days_interval" value="todays(time_interval;)" format="type:num;dec:2"/>