My apologies if this is an obvious question, I've spent the past 3 hours googling for an answer without success. How do I force an end user to enter a specific date time format into a parameter? Obviously, I want to indicate to the user the format I'm requesting. Any help would be appreciated. Thanks.
asked Jul 15, 2013 at 08:02 PM in Default
You can try to split the date and create 3 Textboxes: Year, Month, Day.
Wouldn't it be easier?
answered Jul 16, 2013 at 08:52 AM
If you do not need a default value for the parameter, than you can put the mast ask default value for that parameter and set the parameter type to Text. (The desired format style will be the default value).
Than you create an Internal parameter of type DateTime, which do not allows NULL Value. As default value you will process the value entered in the previous one. (you can Write your custom Code to parse the value to DateTime based on requested format. If it will not match the custom format, it will return NULL.
As the second parameter is set not to accept NULL, report will not be rendered until a proper date in desired format will be entered as the original param.
or Simply as @eghetto mentiond, split it into three params Year, Month, day.
answered Jul 16, 2013 at 01:02 PM