I have tested the following 5 patterns, but none of them could generate a DATE type.
1. value "20230201" + DateFormat "yyyy-MM-dd" → INTEGER
2. Value "20230201" + DateFormat "yyyyMMMdd" → INTEGER
3. Value "20230201" + DateFormat "yyyyMMMdd" → INTEGER
4. Value 2023-02-01 + DateFormat "yyyy-MMMdd" → VARCHAR(4000)
5. Value "2023-02-01" + DateFormat "yyyy-MMMdd" → VARCHAR(4000)
I have checked with TIBCO Support and they say that it is not possible to introspect by Date type with the Local File Storage adapter.
Isn't it a bug that there is an option called DateFormat, but it is not possible to introspect with Date type?
Please fix it.