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

Function::DateTime

Day

Day(DATE VALUE) Day(Current Date) Day(28/01/12) Day(MyDateField)

The day function extracts the day of the month (1-31) from a date value.


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

Parameters


Date Value

Returns/Result


An integer value between 1 and 31

Examples


Examples


day(12/31/01)

Returns:31 (United States format)


day(31/12/01)

Returns:31 (Australian, English Canadian, South American, most European formats)


day(01/12/31)

Returns:31 (Austrian, French Canadian, Taiwanese, South Korean, some European formats)


Reference

day

Type

Date Function

Purpose

The day function extracts the day of the month (1-31) from a date value.

Syntax

day( DATE VALUE)

Returns

An integer value between 1 and 31 

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

Examples

day(12/31/01)

Returns:31 (United States format)

 

day(31/12/01)

Returns:31 (Australian, English Canadian, South American, most European formats)

 

day(01/12/31)

Returns:31 (Austrian, French Canadian, Taiwanese, South Korean, some European formats)

See Also


Month Year Date WeekDay YearDay

On the forum about Day

Beta 8.5 wont open today says my version is too old. I can't find the replacement.

Does anyone know where it is?...

Product: . Written by Kevin O'Donnell 17/12/15 at 13:33:56

Re:Beta 8.5 wont open today says my version is too old. I can't find the replacement.

Hello Kevin,have the same...... And i know that we have to use the latest Version.......But what is new is that we now can not open the covertet Version with Group 8.5 !!!!So how can we go on now ? Will there be a new Version for...

Product: Dataease [{8}]FIVE. Written by Markus 17/12/15 at 19:33:15

Re:Re:Beta 8.5 wont open today says my version is too old. I can't find the replacement.

You should be able to download the latest beta update from the website.But, in regards to Group version. My understanding is, it is going away Jan 2016. Mr DataEase correct me if I wrong here....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 18/12/15 at 02:33:04

Re:Re:Re:Beta 8.5 wont open today says my version is too old. I can't find the replacement.

It is the DataEase 8 Group LICENSE that will disappear from January 1st. After January 1st we will not separate DataEase users by functionality. DataEase is use...

Product: Dataease [{8}]FIVE. Written by DataEase 18/12/15 at 12:16:37

On the blog about Day

DataEase 8 Classic Developer RC1 released Today

We are speeding ahead towards full release later this months, so our RC1 is now available for download/installation.The RC1 still miss a lot of the final configurations, like a full complement of samples/templates etc, but it is very close to...

Product: Dataease [{8}]FIVE. Written by DataEase 26/07/13 at 11:34:13

Early Bird Warning! DataEase 8 Advanced Workshop in Tring (Greater London) Wednesday 26th of February.

In 2013 we were busy with developing our products and adding new functionality, but there is not much point in all this development work if our customers don't take advantage and reap the benefits. With the new functions now almost runni...

Product: Dataease [{8}]FIVE. Written by DataEase 21/01/14 at 17:08:18

How to: Create your own SpeelWeekday() and yes/no for language support

Download Sample The main problem with using an English version of DataEase is things like Spell functions and yes/no. These are functions that a lot of users have grown fo...

Product: Dataease [{8}]FIVE. Written by DataEase 30/09/14 at 22:25:27

DataEase 8.5 RC1 RELEASED TODAY!

Download DataEase 8.5.0.2938 RC1.1 Update: GET() changed name to DEOS() and update to looks, bug fixing. ...

Product: Dataease [{8}]FIVE. Written by DataEase 04/12/15 at 00:12:18

Re:DataEase 8.5 RC1 RELEASED TODAY!

Can this be used to trigger an import function every day at the same time without user action?...

Product: Dataease [{8}]FIVE. Written by Edward Gordley 07/12/15 at 19:58:40