Date Parameter used in filter

Hi sorry if trolling through the other postings that I have not found a
solution to this and it is repetition.
I am trying to set a filter for my table that compares a date from my data
to a date parameter.
I have no problem getting the date parameter with the new funky date picker,
but when I select a date it returns in US format mm/dd/yyyy but my data is in
dd/mm/yyyy. This then causes the report to fall over "value for the report
parameter is not valid".
I would like to maintain the date in the format dd/mm/yyyy for the users
benefit (UK users) but would also like to keep the date picker.
When I pick a date that is the same month and date eg 10/10/2005 all works
fine.
Thanks for the HelpHi,
did you get any resolution for this? I'm having the same issue
thanks
Matt
"Are friends electric?" wrote:
> Hi sorry if trolling through the other postings that I have not found a
> solution to this and it is repetition.
> I am trying to set a filter for my table that compares a date from my data
> to a date parameter.
> I have no problem getting the date parameter with the new funky date picker,
> but when I select a date it returns in US format mm/dd/yyyy but my data is in
> dd/mm/yyyy. This then causes the report to fall over "value for the report
> parameter is not valid".
> I would like to maintain the date in the format dd/mm/yyyy for the users
> benefit (UK users) but would also like to keep the date picker.
> When I pick a date that is the same month and date eg 10/10/2005 all works
> fine.
> Thanks for the Help|||Hi Matt
I did not find a solution on the report designer but when I deploy the
report and run it in explorer it works fine. I suppose this is a solution,
just a pain when trying to work on the design of the report.
Not that I am a fundi in any shape or form but if you need help on this I
can let you know how I set it up.
Steve
"BlackDuck" wrote:
> Hi,
> did you get any resolution for this? I'm having the same issue
> thanks
> Matt
> "Are friends electric?" wrote:
> > Hi sorry if trolling through the other postings that I have not found a
> > solution to this and it is repetition.
> >
> > I am trying to set a filter for my table that compares a date from my data
> > to a date parameter.
> >
> > I have no problem getting the date parameter with the new funky date picker,
> > but when I select a date it returns in US format mm/dd/yyyy but my data is in
> > dd/mm/yyyy. This then causes the report to fall over "value for the report
> > parameter is not valid".
> >
> > I would like to maintain the date in the format dd/mm/yyyy for the users
> > benefit (UK users) but would also like to keep the date picker.
> >
> > When I pick a date that is the same month and date eg 10/10/2005 all works
> > fine.
> >
> > Thanks for the Help|||Yep, I found the same thing. It's a pain. It seems odd that the date picker
obeys your regional settings but the target textbox doesn't.
"Are friends electric?" wrote:
> Hi Matt
> I did not find a solution on the report designer but when I deploy the
> report and run it in explorer it works fine. I suppose this is a solution,
> just a pain when trying to work on the design of the report.
> Not that I am a fundi in any shape or form but if you need help on this I
> can let you know how I set it up.
> Steve
> "BlackDuck" wrote:
> > Hi,
> >
> > did you get any resolution for this? I'm having the same issue
> >
> > thanks
> >
> > Matt
> >
> > "Are friends electric?" wrote:
> >
> > > Hi sorry if trolling through the other postings that I have not found a
> > > solution to this and it is repetition.
> > >
> > > I am trying to set a filter for my table that compares a date from my data
> > > to a date parameter.
> > >
> > > I have no problem getting the date parameter with the new funky date picker,
> > > but when I select a date it returns in US format mm/dd/yyyy but my data is in
> > > dd/mm/yyyy. This then causes the report to fall over "value for the report
> > > parameter is not valid".
> > >
> > > I would like to maintain the date in the format dd/mm/yyyy for the users
> > > benefit (UK users) but would also like to keep the date picker.
> > >
> > > When I pick a date that is the same month and date eg 10/10/2005 all works
> > > fine.
> > >
> > > Thanks for the Helpsql