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

Calculating Number of Months

Can you please assist me with a formula to calculate number for months say from 01/05/1999 to 31/08/2025...

Product: DataEase 8.5 Runtime. Written by Godfrey 13/02/25 at 13:38:17

Re:Calculating Number of Months

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAe4AAAGfCAIAAAAWC6ZlAAAgAElEQVR4Ae2dvYrjSLiw91YOfMG5hslO+GUOGnwHGw4Gg9k7OJ15jKMTdraBMY4WOtnsgO2sYWCDhY0sphk2mmgyHUq/b1Xpt1VS6edZhm1Zqnqr6qnSo1JJ7v4l5D8IQAACEJg4gV8mXn+qDwEIQAACISpnEEAAAhCYPAFUPvk...

Product: DataEase 8.5 Runtime. Written by DataEase 17/02/25 at 16:27:41

Re:Re:Calculating Number of Months

... assumes stop-date &gt;= start-dateif year(stop-date) = year(start-date)then Months = month(stop-date) minus month(start-date) plus 1<span s...

Product: DataEase 8.5 Runtime. Written by Suzanne Michelle 20/03/25 at 15:38:26

Re:Re:Re:Calculating Number of Months

not bad...

Product: DataEase 8.5 Runtime. Written by Ihor Zakharchenko 21/03/25 at 12:24:35

On the blog about Month