Hi,
We have a scenario in our project wherein we have to display a particular date column which has the value 01/01/0001 in MM/DD/YYYY format, the data type of the column in the database in DATETIME.
But the moment we execute the report with this column which has the value 01/01/0001 we see the result as 01/01/1, basically the preceding “000” is not getting displayed in the report. All other rows which have the valid dates are being displayed in the correct format.
Can you please suggest if we have any workarounds for this scenario?
We have a business scenario where in we are loading this value (01/01/0001) when the date column has NULL value in the database itself.