CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2008-r2ssrs-2012
Dom Vito
Dom Vito

Reputation: 567

Date parameter in query designer SSRS

Every time I enter in a date parameter to test a query in the query designer in SSRS, I get an error "ORA-01843: not a valid month".

I typically am testing a date in the following formats: 1/1/2017 1-1-2017 30/12/2016

And I still get the error. How does it want me to input the date? I am losing my mind.

Upvotes: 1

Views: 1359

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10870

Ugh - you're connecting to an Oracle database.

The date must be cast as a date.

Use:

TO_DATE('2017-01-01', 'yyyy-mm-dd')

Upvotes: 2

Related Questions