Going in circles in my mind about the formula to calculate a timestamp attribute to 48 hours after CURRENT_TIMESTAMP to set a temporary password expiration.
Anyone got it?
Temp password expiration in X hours after current time
Temp password expiration in X hours after current time
Tom - V8.8 build 3137 - MySql / PostGres
Re: Temp password expiration in X hours after current time
TIME_ADD
Description:
Returns the timestamp resulting from adding/subtracting the specified number of hours to the specified timestamp
Parameters:
An expression producing timestamp and an expression producing a number to be added or subtracted (if the number is negative) to the timestamp
Example:
If TIME_ADD (Account.OpeningTime), 4) = 07/04/2004 12:00 Then …
Description:
Returns the timestamp resulting from adding/subtracting the specified number of hours to the specified timestamp
Parameters:
An expression producing timestamp and an expression producing a number to be added or subtracted (if the number is negative) to the timestamp
Example:
If TIME_ADD (Account.OpeningTime), 4) = 07/04/2004 12:00 Then …
Re: Temp password expiration in X hours after current time
Thanks Renur.
My rule:
SystemUser.PasswordTemp_Expires_ts=TIME_ADD(CURRENT_TIMESTAMP,48)
Thinking I should probably make the 48 a SystemSetting as well vs hard coding in the rule.
My rule:
SystemUser.PasswordTemp_Expires_ts=TIME_ADD(CURRENT_TIMESTAMP,48)
Thinking I should probably make the 48 a SystemSetting as well vs hard coding in the rule.
Tom - V8.8 build 3137 - MySql / PostGres