Forum Discussion
Help with datetime
Hi all... I need help. I need filter querry help with this #"Filas filtradas1" = Table.SelectRows(#"Columna condicional agregada1", each [FechaVencimiento] < DateTime.LocalNow() +7), ...
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.
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.
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-2019i Change DATE to DATETIME type of date.. and work.
Thanx..