Good night noble friends, what is the best expression to choose the most recent data from a column?
This is not giving me the expected result!
I want to select the most current value from the column, based on date and time..
ANY(SELECT(Senha de Acesso ao Cadastro[NovaSenha],
TODAY() <= DATE(
ANY(
TOP(
SORT(
SELECT(Senha de Acesso ao Cadastro[Submission Date], TRUE ),
true
),1
)
))+3
))
_______________
My goal is to make a password obsolete in 3 days.
Example: The password created now, after 3 days it no longer serves.
Pasando para informar que he logrado con esa:
Compartiendo con todos para contribuir un poco con los que necesiten!
Cordial saludo!
ANY( SELECT( Senha de Acesso ao Cadastro[NovaSenha], AND( [Senha_ID] = MAXROW("Senha de Acesso ao Cadastro", "_ROWNUMBER"), TODAY() <= DATE([Submission Date])+3 ) ) )
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |