Easy to Create, Easy to Change - Easy to use!

Function::DateTime

Month



Parameters


Returns/Result


Examples


Reference

month

Type

Date Function

Purpose

The month function extracts the month (1- 12) from a date value.

Syntax

month( DATE VALUE)

Returns

An integer value between 1 and 12 

The date format selected using the International option in the Windows Control Panel changes the date sequence but does not affect which value is returned by a Date function.

Examples

month( 12/31/99)

Returns: 12 ( North American format)

 

month( 31/12/99)

Returns: 12 (European format)

 

month( 99/12/31)

Returns: 12 (Metric format)

See Also


On the forum about Month

We are not sure what different for DE8.5 and DE8.6 which is new launching this month?

We are not sure what different for DE8.5 and DE8.6 which is new launching this month?Can you show something example for us to know better with this product?...

Product: Dataease [{8}]FIVE. Written by Mohd Sedik Zakaria 11/10/17 at 05:02:05

Re:We are not sure what different for DE8.5 and DE8.6 which is new launching this month?

Hi.There is no set release date for 8.6 yet. When the version is released we will publish the full list of news and differences between 8.6 and 8.5...

Product: Dataease [{8}]FIVE. Written by DataEase 13/10/17 at 12:09:45

On the blog about Month