Solved: Help with datetime

Anonymous · ‎09-10-2019

Hi all...

I need help.

I need filter querry

help with this #"Filas filtradas1" = Table.SelectRows(#"Columna condicional agregada1", each [FechaVencimiento] < DateTime.LocalNow() +7),

Dont work.. how filter for fechavencimiento today to 7 days more.

please help.

ibarrau · ‎09-10-2019

Hi. You can't add a plus and number just like that to date. Try this

#"Filas filtradas1" = Table.SelectRows(#"Columna condicional agregada1", each [FechaVencimiento] < Date.AddDays(DateTime.LocalNow(), 7) ),

Hope this helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

ibarrau · ‎09-10-2019

Hi. You can't add a plus and number just like that to date. Try this

#"Filas filtradas1" = Table.SelectRows(#"Columna condicional agregada1", each [FechaVencimiento] < Date.AddDays(DateTime.LocalNow(), 7) ),

Hope this helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

Anonymous · ‎09-10-2019

thanx for help. This error

Expression.Error: No se puede aplicar el operador < a los tipos DateTime y Date.
Detalles:
Operator=<
Left=17-09-2019 10:31:28
Right=30-10-2019

Anonymous · ‎09-10-2019

i Change DATE to DATETIME type of date.. and work.

Thanx..

Help with datetime