Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Categories data sources
Created by Guest
Created on Feb 9, 2023

Local File Storage adapter cannot estimate date type

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.

  • Attach files