Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help needed with Report Builder

I am trying to put in a date parameter and having issues. Please Help.           Query (1, 104) DAX comparison operations do not support comparing values of type Date with values of type ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    I was able to format my date using expressions and now that report functions as it should

    Thank you for the input

    Jamie

  • Anonymous's avatar
    Anonymous
    5 years ago

    =Format((Parameters!FromFinalTablePostedPostingDate.Value), "MM-dd-yyyy")

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I have changed the parameter type to Date/Time and now get this error. Help Please

 

 

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

 

After changing the parameter type to Date/Time, you could give it a default value in the Date/Time format. Don't forget the time part.

 

If the parameter is used to filter a specific field, you can also check the parameter option for the field when you design the query. Then a parameter with the same name as the field will be added. In this way, it will select a proper data type for the parameter according to the field automatically. You can modify the properties of this parameter later just like modifying other parameters.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I must be missing something I am getting this error now,