topic Re: How to set calender option in date parameters in report Builder? in Report Server

How to set calender option in date parameters in report Builder?

Anonymous — Sun, 03 Jan 2021 20:38:38 GMT

Hello guys,

I need an urgent solution for Report Builder. I have created the parameters subscriber number, start date, and end date. For a moment I have the date in text format in default.I want to change the format of the date from the text to the date format so that I can apply the calendar option for my customer. Can anyone tell me how to change the date format in the report builder?

I have tried to change the format of date by selecting data type in parameter properties but it didn't work. I think I have to change something in Query. Can someone tell me what I am missing here?

Thanks in advance 🙂

Re: How to set calender option in date parameters in report Builder?

DavisBI — Mon, 04 Jan 2021 08:18:36 GMT

Hi, Anonymous

Try this function : cdate()

Re: How to set calender option in date parameters in report Builder?

Anonymous — Mon, 04 Jan 2021 08:38:17 GMT

Thanks for the reply Davis. Could you tell me where I can use this Cdate() function and what is the syntax for that ?

I am quite new to this report builder thing.

Re: How to set calender option in date parameters in report Builder?

Anonymous — Mon, 04 Jan 2021 09:46:12 GMT

Hi DavisBI

I have tried this:

But still I am seeing blank values in my data.

Re: How to set calender option in date parameters in report Builder?

v-deddai1-msft — Tue, 05 Jan 2021 05:30:02 GMT

Hi Anonymous ,

Show some sample data and we might be able to help you convert it with formula or format feature.

Or you can check the documents below about how to convert format in power bi.

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

https://community.powerbi.com/t5/Desktop/how-to-change-text-to-date/td-p/16067

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

Best Regards,

Dedmon Dai

Re: How to set calender option in date parameters in report Builder?

Anonymous — Tue, 05 Jan 2021 09:43:08 GMT

Hi v-deddai1-msft

Currently, I am using Report Builder to set the Parameter option for my customer. The data source which I am using is Oracle.

This is the step by step process I am doing:

Re: How to set calender option in date parameters in report Builder?

v-deddai1-msft — Wed, 06 Jan 2021 06:13:37 GMT

Hi Anonymous ，

Would you please try to change the orderdate to date type when you query the table in report builder. Please try something like:

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

Best Regards,

Dedmon Dai

Re: How to set calender option in date parameters in report Builder?

Anonymous — Wed, 06 Jan 2021 14:29:30 GMT

Thank you Dedmon. It worked.