Did this article resolve your question/issue?


Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025



How to convert a date integer to a date format

« Go Back


Article Number000020195
Question/Problem Description
How to convert a date integer to a date format
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
The 4GL function DATE allows to convert string and integer to a date format. It converts also an integer into a date:

DATE ( integer-expression )

However in this case the integer-expression is an expression that evaluates to an integer value that represents the number of days since the origin of the 4GL date data type.

Probably you'd like to convert an integer that contains the date in itself. Like for example 100876.
In this case is more convenient to use the double conversion:

Integer ---> String ----> dateFormat

As for example:
myInt = 100876.myDate = DATE( STRING (myInt)).
As the string value must have the format specified by the Date Format (-d) startup parameter (the default is mdy), also the integer expression should have the same format.
Last Modified Date9/14/2015 1:15 AM