Date Function Returns a Numeric Value (i.e., Julian Date)
Returns a date value when given the month number (mm), the day number (dd) and the year number (yyyy). The range of mm must be from 1 to 12. The range of dd must be from 1 to 31. The range of yyyy must be from 100 to 9999. This function does not check for valid values [i.e., mkdate(2,31,2026) is not valid]. If an invalid value is used, this function will give unexpected results.

Function Use

This function can be used when filtering records or formatting how data is displayed or returned.

Filtering Examples

The following examples are ways in which you can use this function to filter records.

You want to see all statements in the Statement Manager with a Date of 07/18/2026.

Date = MKDATE(07, 18, 2026)

Formatting Examples

You want a specific date to be displayed. The following example assumes that you want the date 12/22/2026 returned.
 

Expression:

 MKDATE(12,22,2026)
  Returns: 12/22/2026
 
You want the first day of the current month returned. The following example assumes that the current system date is 01/14/2026.  
  Expression: MKDATE(MONTH( ),1,2026)
  Returns: 01/01/2026
 
You want a specific date to be displayed. The following example assumes that you want the date 09/08/2026 to be returned.  
  Expression: MKDATE(09,08,26)
  Returns: 09/08/2026

Tip: The DATEADD( ) function is similar to the MKDATE( ) function, but in some scenarios may be easier to use.

Other Resources