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

[Anonymous]

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 🙂

[v-deddai1-msft · Accepted solution]

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

[Anonymous]

Thank you Dedmon. It worked.

[v-deddai1-msft]

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

[Anonymous]

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:

Oracle Query which I am using to create parametersQuery tested successfully in Oracle1st Parameter created: Subscriber Number2nd Parameter: Start date in text format3rd parameter : End Date in text formatWhen I am entering start date and end date in text format , It working fine.Start date in date formatChoosing start and end date in calender formatIt throwing this error whenever I am selecting date in calendar format

[DavisBI]

Hi, @Anonymous 

Try this function : cdate()

[Anonymous]

Thanks for the reply Davis. Could you tell me where I can use this Cdate() function and what is the syntax for that ?I have the ordered date here where the date is in a text formatFrom the same date format I have made the parameters Start Date and End Date.

 I am quite new to this report builder thing. 

[Anonymous]

Hi @DavisBI 

I have tried this:

But still I am seeing blank values in my data.