Date data type

Official Content
This documentation is valid for:

To store date values. When defining a Date data type, it is not necessary to specify other properties. The user must specify the associated picture.

The following table illustrates the conversion done by GeneXus according to the DBMS:
 

DBMS Conversion
Oracle DATE
DB2 Universal Database DATE
Informix DATE
SQL Server DATETIME
Access DBDate
DB2 for iSeries CHAR(8) or DATE1
DBF DATE(8,0)
PostgreSQL DATE

1 Depends on the Date data type definition environment Property.

Pictures

The following link illustrates the pictures that can be applied to Date data types: Picture Properties Group


Static methods

Date.New(Year,Month,Day)

Examples

&ExpirationDate = Date.New(2018,6,10)
If &ExpirationDate >= Date.New(2018,6,10)
   msg("The date has expired")
EndIf

See also

DateTime data type
Data types list







Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.