Wednesday, March 21, 2012

Datetime Parameters reset to String

When I go to Report > Report Parameters... in VS, I create date parameters and specify the type as datetime. I then add the parameters to my SQL statement. I then go back to look at the parameters and they have changed to string. This happens every time I make a modification to the SQL statement. Is this a bug, or am I missing a step? I thought someone would have asked this before, but I can't find a post for it in this forum.

Thanks in advance,

Scott

Parameter's type can change to string, but it should only happen once. What version are you using?|||I'm using 2005. I'm not 100% sure but I'm fairly certain that it happens every time I change the SQL statement.|||Its Not a bug, Its a Feature :)))

But yes - I don belive its a bug.
It happened to me a few time that when I played with the dataset its changed my parameter type from dateTime to string.

If this will be your only problem with the dateTime parameter you should be happy.
Its also have some problems with some localization sometimes....

No comments:

Post a Comment