开发者

SSRS Date Culture Error

开发者 https://www.devze.com 2023-04-06 16:47 出处:网络
I\'ve got a strange error when trying to pass date parameters to SSRS. All of the dates are retrieved using a DatePicker and validated so开发者_如何学运维 that only real dates are allowed.

I've got a strange error when trying to pass date parameters to SSRS.

All of the dates are retrieved using a DatePicker and validated so开发者_如何学运维 that only real dates are allowed.

However passing dates in the format dd/mm/yyyy causes SSRS to throw TypeMissmatchException if the day is 13 or higher.

I'm assuming this is due to the culture of SSRS being set to EN-US, is it possible to change this? or do I need to convert all dates that I send SSRS into American format.


The easiest way is to send dates in military format yyyy-mm-dd if possible as that is always interpreted correctly regardless of culture settings.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号