SupportCategory: Simple Object DesignerEliminate Null Date of 1/1/1753
Jason asked 3 months ago
Hi Erik, Added custom fields type "Date" and Null values pull into Excel as "1/1/1753".  I am pinging Odata feeds using Jet Reports.  I read this null date value is a SQL standard and can't find a solution around it.  I'd like to use the "Date" field type for consistency.  Any work around?  Thanks, enjoying the software!
1 Answers
hougaard Staff answered 3 months ago
Hi Jason, 1/1/1753 is the way Business Central internally stores a blank date. This is not something that is within my control. I'm quite surprised that Jet doesn't read it right, they do know BC.