| String |
String fields support a string of text characters. |
| Small integer |
Small integer fields support whole numbers between -32768 and 32767. |
| Integer |
Integer fields support whole numbers between -2147483648 and 2147483647. |
| Big integer |
Big integer fields support whole numbers between -9223372036854776000 and 9223372036854776000. |
| Float |
Float fields support fractional numbers between approximately -3.4E38 and 3.4E38. |
| Double |
Double fields support fractional numbers between approximately -2.2E308 and 1.8E308. |
| Date |
Date fields support values in the format yyyy-MM-dd HH:mm:ss, for example, a valid value is 2025-12-31 13:30:30. If the date values are stored in a different format, use the Create date time tool to calculate a date field. |
| Date only |
Date fields support values in the format yyyy-MM-dd, for example, a valid value is 2025-12-31. If the date only values are stored in a different format, use the values as input to the Calculate field tool to calculate a date only field. |
| Boolean |
Boolean fields support values of True and False. If a field contains integer representations of Boolean values (0 and 1), use the Update fields tool to cast the integers to Boolean values instead. |