monthvalue(
DATE
)

The monthvalue( function extracts the month from a date as a numeric value.


Parameters

This function has one parameter:

date – date value (see the date( and today( functions.)


Description

This function extracts the month from a date as a numeric value (1 = January, 2 = February, etc.).

monthvalue(today()) ☞ 3

Note: This function is equivalent to:

val(datepattern(thedate,"MM"))

History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.