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 >= 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
Register
Sign In
