2018.1

Table Of Contents
Function Description
l properCase() first character of each word to uppercase and all other
characters to lowercase.
Date, date/time and time functions
l date()
l dateLong()
l dateMedium()
l dateShort()
l dateTime()
l dateTimeLong()
l dateTimeMedium()
l dateTimeShort()
l time()
l timeLong()
l timeMedium()
l timeShort()
Note
The locale also influences the output of the different Date functions; see "Locale" on page654.
Tip
To format a date from a date field in the record set, you can enter a custom pattern via the Text
Script Wizard; see "Using the Text Script Wizard" on page671, "Formatting variable data" on
page675 and "Date and time patterns" on page1065).
date(value, pattern)
Formats a date object using a custom pattern.
Page 1061