cancel
Showing results for 
Search instead for 
Did you mean: 

Webi Date Format Issue

0 Kudos

I have a webi report with date field in report and is being used in prompt as well with source as SQL Server. When I run the report in UAT, I see no issues; however, the same report is throwing error in PROD.

"Conversion failed when converting date and/or time from charater string."

Date Field: convert(date, getdate())

Can someone advise here.

TammyPowlas
Active Contributor

Thank you for your question. Please note that I updated the primary tag to WebI - please be more careful when selecting tags in the future.

Accepted Solutions (1)

Accepted Solutions (1)

omacoder
Active Contributor
0 Kudos

Also make sure the middleware being used between uat and prd is the same.

Answers (1)

Answers (1)

daniele_tiles2
Active Participant
0 Kudos

Hi Ram,

did you check the user used both in the SQL Server and in the Universe Connection are the same?

I would strongly suggest to check also the prm file in the BI server, to check if it's coeherent with your format for the date (usually it's that the problem, see the following SAP Note

https://launchpad.support.sap.com/#/notes/2237919).
HTH

Daniele