error [conversion failed when converting date and/or time from character string]

[former_member1377874]

Greetings,

I have some difficulties when placing my query on UDV, below is my query to get price list based on document date in the active Sales Order

SELECT Price FROM ITM1 T0

INNER JOIN OPLN T1 ON T1.[ListNum] = T0.[PriceList]

WHERE ItemCode = $[RDR1.ItemCode]

AND Year($[ORDR.DocDate]) = Year (T1.[ValidFrom])

the date display in general settings - tab displays is DD/MM/YY

I recognize it has no problems from 1st Jan 2021 to 12th Jan 2021 when 13th Jan 2021 it shows error like this : [conversion failed when converting date and/or time from character string], so I checked my query using user queries and shows like this

SELECT Price FROM ITM1 T0

INNER JOIN OPLN T1 ON T1.[ListNum] = T0.[PriceList]

WHERE ItemCode = N'00017-25MG '

AND Year(N'13.01.21')= Year (T1.[ValidFrom])

if I change general setting - tab displays date format to MM/DD/YY my query has no problems, but my clients would not like that option

please help me with this query

Thank you very much

[sveabecker]

Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Regards, Svea

SAP Community Global Moderator