Skip to main content
F
FrankDK
Contributor
May 18, 2022

Sql Editor Component Date type 'NULL'

  • May 18, 2022
  • 2 replies
  • 0 views

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 the sql datetime type.

MicrosoftTeams-image (1).png

I just want to show a blank value instead of "1/1/1900". Anybody solved this?

 

Cheers Frank

2 replies

C
Cosimo
Contributor
May 18, 2022

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). 

    T
    TonyToniTone
    May 19, 2022

    Some good discussion on this topic online

    https://stackoverflow.com/questions/13934621/insert-null-empty-value-in-sql-datetime-column-by-default

    Terms & ConditionsAccessibility statement