In a datasheet, is there a way to format a datetime value with hour and minute only (no seconds) if there is a stored time value, but if the value stored is only a date, show as mm/dd/yyyy?
The goal is to have these outcomes:
enter a plain date 10/11/2023, show 10/11/2023
enter a date time...