How to get date difference between last logon and last password reset dates in Active Directory
Hi Guys, I would like to get the date difference between Last Logon and Last Password Reset columns and the display a warning or text that the user hasn't reset their password in x amount of days. This is what I am using now but does not display the correct information: Measure = VAR Created = MAX ( user[user.lastLogon].[Year]) VAR Closed = MAX ( user[user.pwdLastSet].[Year] ) VAR NoOfDays = IF ( Closed > Created, DATEDIFF ( Created, Closed, YEAR), DATEDIFF ( Closed, Created, YEAR) ) RETURN IF ( NoOfDays >= 1, "User account Fine", "Password Needs to be Reset )