Forum Discussion

ceciliatc's avatar
ceciliatc
New Member
1 year ago
Solved

parametros

hola   estoy intentando crear un parametro con fechas pero me sale este error, alguien sabe q estoy haciendo mal?    
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.