Nintex: How to retrieve a user password expiry date

Hi ​@guru2000,

Unfortunately, AD doesn’t make this easy. The only attribute they give you is when the password was last set. To make things worse, it is in Windows FILETIME value , which is measured in 100-nanosecond intervals

Example: 131166582658295684

This has to be divided by 10,000,000 as there are 10,000,000 FILETIME units per second, which equals 13116658265.8295684

We then have to deduct 11644473600 to allow for the difference between the Windows File value Epoch and the Unix Epoch. The output will be a UTC UNIX time stamp: 1462184665.8295684

You then use a convert date action to convert to a human readable date.

 

• Start:

  • Input a Unix timestamp value, such as 1672531200 (corresponds to 01/01/2023 00:00:00 UTC).

• Set Workflow Variables:

  • EpochDate = 1/1/1970 00:00:00.

• Add Time:

  • Add the value of UnixTimestamp as seconds to EpochDate.

• Store the Result:

  • Save the result in ConvertedDate.

• Output:

  • Use an email, log, or SharePoint field update to display the converted human-readable date.

Once you know when the password was set, you can then add the company policy for password expiry, say 90 days to work out when the password will expire.