Date field to be empty when Null

[eworthington]

Good day!

When displaying dates from the imported data, the default date 01-01-1900 displays when the imported date field is Null. Is there a way to display the field as empty when Null?

1. Date must display when available. Date must not display when Null
2. Is there a way to truncate the time? Only Hrs and Mins are needed

Screenshot is in google docs here: https://docs.google.com/document/d/1O7LyBAwnyeVi2qcCQZA3b93hF1vz17txT70PhZOSXw8/edit?usp=sharing

As always, thank you!

Ellyn

 

[LurkingKiwi]

When you say "Default date", is that a database column default, or an import default?
I suspect those default dates are in your database now.

You could use a view to convert out-of-range dates to NULLs, or a custom formatting function (see manual 10.3) with a date comparison to return without printing if <= 1900-01-02 or the format you want.

 

[eworthington]

Thank you for your reply.

When the imported date field is empty (Null), we would like it to also be empty in the the corresponding date field in DadaBik.

Otherwise, I will share your response and see if that works.