The list I have of functions in the Database Calculation do not include many of the available functions I needed, e.g. DateToText, TodaysDate,etc.
The functions available in the Specify Calculation window are all the available functions. There is no DateToText or TodaysDate function - use GetAsText() and Get(CurrentDate), respectively.
A full list is available in the reference section of the help: