Functions (all)

Date

Function Name:
Date
Description:

This a Type-Specifier function. It takes a date parameter and simply returns it. Its primary use is when you want to ensure that a data reference or prompt value is treated as being of type date in contexts where its role might otherwise be ambiguous.

Other type-specifier functions which can be used in a similar way are Text, Number, Float, Bool and Item.

Note: In version 3.1 there was a Date function which took 3 number parameters, specifying the year, month and day of a date, and returned the date. This function is now the DateAt function. The old usage is still supported for backwards-compatibility only, but should not be used in future - use DateAt instead.

Minimum FH Version:
4.0
No. of Parameters:
1
Return Type:
Text
Parameter 1:
Date
Examples:

=Date(["Enter date"])