Forum Discussion
SQL Date format not recognized in Paginated report
Riskworks114 really not sure what you are trying to achieve here, could you please provide a bit more context?
Yes, absolutely. A report that I am moving from RRSR to PBI has a query that includes a date conversion for Date data type to YYYYMMDD format with: convert(VARCHAR (10),ThruDt , 112). The data for this column is from the parameter @ThruDt which is part of a larger query that populates a tep table. This works in SSRS and in SSMS. In PBI the format qualifier is ignored, and the date displays as a normal date type. I've tried severall things, including adding a date column populated with GETDATE() which the format worked.
I added a data set with only the parameter and getdate columns and that works. It's kind of strange that the format is not working in the query that is pulling data from a database along with a parameter column where the sql format is ignored. I HTH. Thx.