The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

FrankDK's avatar
FrankDK
Contributor
4 years ago

Sql Editor Component Date type NULL

Scenario: I have a Sql Editor component, with a couple of date-columns. If the value in the belonging custom-table is value NULL, then the value in the editor will always be the minimum value of th...
Methodology
Cosimo's avatar
Cosimo
Contributor II
4 years ago

I don't think you can display a blank value for a SQL date field as 1/1/1900 represents null. My workaround was to convert a date field to string and store dates as strings. If the field value is null then the table editor displays it as blank.

The only drawback is that you lose functionality that are specific to date fields (i.e. filter using calendar).