Data 360: Specifying NUMBER(08) or NUMBER(09) in a formula field in Data 360 results in "Invalid Formula"

By removing the leading zero from the number specified in the NUMBER function, the specified number will be treated as a decimal number.

If it is absolutely necessary to add a leading zero to the number specified in the NUMBER function and you need to represent a number greater than or equal to 8, you can avoid the "Invalid Formula" error by adding numbers up to 7, as shown below. The following formula returns "2008-01-01".

e.g.
DATE((2000 + NUMBER(07 + 01)), 01, 01)

Additionally, you can specify it as an octal number as shown below. The following formula also returns "2008-01-01".

e.g.
DATE((2000 + NUMBER(010)), 01, 01)