parametros

[ceciliatc]

hola

estoy intentando crear un parametro con fechas pero me sale este error, alguien sabe q estoy haciendo mal?

[Anonymous]

Hi @ceciliatc 

This error is because you are comparing data of type DateTime and DateTimeZone.

As lbendlin mentioned, you can use DateTime.From() function to convert DateTimeZone to DateTime type, moreover, you can also use DateTimeZone.RemoveZone() function to remove the time zone information of DateTimeZone, try the following code:

= Table.SelectRows(#"Changed Type", each DateTimeZone.RemoveZone([Date]) >= RangeStart and DateTimeZone.RemoveZone([Date]) <= RangeEnd)

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

[lbendlin]

Use DateTime.From( )  to make the data types match.

[ceciliatc]

now I am getting this

[lbendlin · Accepted solution]

couple things:

- Use DateTime.From([Date])   - RangeStart and RangeEnd are already in the right format.

- What's the 0 supposed to do?  Drop that

- Only one of the parameters can be inclusive, usually RangeStart.  Make RangeEnd exclusive.

RangeStart <= DateTime.From([Date]) and DateTime.From([Date] < RangeEnd