handle empty data formats (date/datetime/number) gracefully