Report parameter - date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Franklin - 31 Aug 2005 13:57 GMT

I have developed few reports using reporting services (service pack 2), but
still facing some problem in the date parameter and would look for help /
share here. Thanks advance!

1) How RS treat the date format?
YYYY-MM-DD (the data is correct when i use this format)
DD/MM/YYYY
MM/DD/YYYY

What is the purpose to define the date parameter as "MM/DD/YYYY" from the
"Expression" windows?

Any way to limit the input date format or any method to convert the format
to YYYY-MM-DD if user really input the format as DD/MM/YYYY or MM/DD/YYYY?

2) Anyone know how to use date time picker in RS, or possible to use it? I
believe if RS could use the date time picker, I don't need to worry the
parameter format

Reply to this Message

JB - 31 Aug 2005 14:18 GMT

Hi,

have a look at this article:

http://www.databasejournal.com/features/mssql/article.php/2197931

You'll find the way to solve your problem (I had the same problem and by
converting the date with the CONVERT function in my SQL query I managed to
solve it).

If you have some time could you take a look at my post (just after yours),
maybe you have the solution.
Thanks,

Signature

> I have developed few reports using reporting services (service pack 2), but
> still facing some problem in the date parameter and would look for help /
[quoted text clipped - 14 lines]
> believe if RS could use the date time picker, I don't need to worry the
> parameter format

Reply to this Message