Stores Date values.
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.
The following link illustrates the pictures that can be applied to Date data types: Picture Properties Group
Static methods
Date.New(Year,Month,Day)
Sample
&ExpirationDate = Date.New(2018,6,10)
If &ExpirationDate >= Date.New(2018,6,10)
msg("The date has expired")
EndIf
DateTime data type
Data types list