S
Simon L. Prinsloo
Guest
I agree with @patrick Patrick Tingen in that this is expected. My reason is as follows: In the case of DATE( month, day, year) you are not working with a date, but with three integers. The third integer must be used as is, otherwise there will be no way to use that format to obtain a date in the first century. -yy applies only to dates REPRESENTED without a century and has most likely started out as a method to simplify data capturing by allowing for the omission of the century. If the system did not work as it is now, the following code would malfunction. DEF VAR dd AS INT NO-UNDO. DEF VAR mm AS INT NO-UNDO. DEF VAR yy AS INT NO-UNDO. DEF VAR dte AS DATE NO-UNDO. ASSIGN dte = 01/26/066 dd = DAY(dte) mm = MONTH(dte) yy = YEAR(dte) . MESSAGE DATE(mm, dd, yy) VIEW-AS ALERT-BOX. As it is today, the DATE function would bring us back to the original date, regardless of the century of the date.
Continue reading...
Continue reading...