G
George Potemkin
Guest
> I would expect the year to be 66 just not 066. Your expectation is correct: YEAR(DATE (01,26,66)) returns 66. But 66 AD can't be displayed using "99/99/99": STRING(DATE (01,26,66), "99/99/99") ** Value 26/01/066 cannot be displayed using 99/99/99. (74) The same case as DATE (01,26,10066). It will not displayed as 01/26/66.
Continue reading...
Continue reading...