Cognos report to check last password change date

[viv_prabha]

Hi,

I have created a report with below data items to get last password change date

[Expense].[Employee Information].[Country]

[Expense].[Employee Information].[Employee ID]

[Expense].[Employee Information].[Employee Name]

[Expense].[Employee Information].[Active]

[Expense].[Report Header Information].[Employee E-mail Address]

[Expense].[Employee Information].[Password Change Date/Time]

Data item "Password Change Date/Time" is not providing the correct details. Either provide blank or incorrect date. Could you please suggest how to fix this issue to get correct details.

Note- All these data items are under one query. 

Regards

Vivek

[KevinD · Accepted solution]

@viv_prabha so, I take it you tested this out by changing your own password and then running the report? Is that correct? Or how do you know the date is incorrect? 

[viv_prabha]

Hi Kevin,

I have tested with some other users and found that change date field is blank. Even in some other users it is showing incorrect date (start with 1990 year) which is not relevant. 

[viv_prabha]

Looking for solution. If you have any?