How to change a date field from a random date to a blank field

[dlemoine]

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?

[Adarsh_R3]

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

[dlemoine]

It seems to do this each time there is a blank field in the source data.

My workflow is attached

[DavidSkaife · Accepted solution]

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?

[dlemoine]

Thank you that has worked