Forum Discussion
parametros
hola
estoy intentando crear un parametro con fechas pero me sale este error, alguien sabe q estoy haciendo mal?
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
4 Replies
Use DateTime.From( ) to make the data types match.
now I am getting this
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
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.
