Report Editor Returning 1900-01-01 when field is null

I have a report which has a column to show date field. When I execute the query in object browser, the date column shows me blank value(when no data), but while generating the report using report editor, the default value of the column shows 1/1/1900 12:00:00 AM

0 Markus Weiss-Ehlers over 3 years ago

Which version are you using?

What type of report query are you using?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 ashmitbagga over 3 years ago in reply to Markus Weiss-Ehlers

Version is 8.0. and I am using SQL as query module in Report Editor. Not sure what is meant by report query.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers over 3 years ago in reply to ashmitbagga

So you are using the SQL report query type.

Did you check the hints mentioned here? https://support.oneidentity.com/technical-documents/identity-manager/8.1.3/configuration-guide/84#TOPIC-1481218

Thing is, that 1/1/1900 looks like the default date if you are using a SQL Convert function like ISNull.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Endpoint Privilege Management

Report Editor Returning 1900-01-01 when field is null