Using the 7.0.1 VStudio for both a local VDB an VReport (On Windows):
In studio the Locale starts out blank and I can't set a specific Locale. I click on the editing pencil and set it to en_US but it will not persist. It remains blank.
Design a local DB - one of the fields (sDate) is a date field (MM/DD/YYYY) set for each record.
Query: SELECT * FROM tblCOPP WHERE sDate BETWEEN $P(startDate) AND $P(endDate)
Then I use the new interactive function in VStudio for parameters, I set two: (same parameter names as in the DB query)
startDate (inDate)
endDate (inDate)
Run the report and set the two dates via the popup in the MM/DD/YYYY format and the report errors out telling me the date parameter is invalid (illegal character at position yada yada) because the interactive parameter date has been encoded in the YYYY-MM-DD format instead of the MM/DD/YYYY I am using.
In the query editor if I set a default date for my two parameter fields it works fine when you click the test tab.
Any idea what I am doing wrong?
Scott