[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: DATE function

  • Thread starter Thread starter Patrick Tingen
  • Start date Start date
Status
Not open for further replies.
P

Patrick Tingen

Guest
And the outcome is 100% correct. It is not a matter of separator, it is a matter of datatype. When you pass in 01,26,66 you actually pass in 3 integers. When you pass in 01.26.66 or 01/26/66 you pass in a date. Consider the possible ways to call the DATE function: DATE ( month , day , year ) DATE ( string ) DATE ( integer-expression ) DATE ( datetime-expression ) when using DATE(1,26,66) you get (and should get!) 26 january of the year 66. Not 1966. If you wanted that you should have used DATE(1,2,6,1966) instead. Funny though is that it is possible to notate a date with dots instead of slashes. Didn't know that.

Continue reading...
 
Status
Not open for further replies.
Back
Top