I am preparing a report and when the report generates in excel where a date field is blank it is entering a date of 1753-01-01. How do I get this date field to be blank on the report?
Solved! Go to Solution.
hi @dlemoine
by default there shouldn't be any values in blank records. But please check the flow again.
It would be helpful if you share your flow
Hi @dlemoine
You can use a formula to null any field that has that specific date in it; for example:
IF [DateField] = '1753-01-01' THEN NULL() ELSE [DateField] ENDIF
However you may need to look into why it is populating the empty field with a date; for reference 1st January 1753 is the earliest date an SQL Server Date Field will allow, is it definetely not coming through from one of the databases?
Thank you that has worked