Simplicty and flexibility!


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 grohmann.papier@t-online.de 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

I lost the one CDF that I use almost every day :(

I have lost one precious CDF called "wizModifyImport".  I used it for changing file name in a pre defined import.  It used to run a "modimp.exe" file and had two parameters : DBIFile and DataFile.Someone here happens to have this CDF...

Product: LegEasy DOS. Written by Steinar Svinø 03/12/20 at 18:29:27

Re:I lost the one CDF that I use almost every day :(

Is this a DOS or a Windows CDF?...

Product: LegEasy DOS. Written by DataEase 04/12/20 at 11:14:56

Re:Re:I lost the one CDF that I use almost every day :(

Dos 5.12...

Product: LegEasy DOS. Written by Steinar Svinø 04/12/20 at 11:42:04

Re:Re:Re:I lost the one CDF that I use almost every day :(

The only one we have is the Windows version of WizUtil which is why I asked. I have sent out a request to some experience DFD people and we will see what they come back with....

Product: LegEasy DOS. Written by DataEase 11/12/20 at 11:48:02

Re:Re:Re:Re:I lost the one CDF that I use almost every day :(

Hi. Have not been able to find it, but have had a look at the DBI file structure. It is a binary file so can't be created directly in an editor but the format is very simple so we would be able to build a tool if it is a life or death situation. ...

Product: LegEasy DOS. Written by DataEase 14/12/20 at 12:34:56

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


dg3_HelpView