Convert string value to Date

If I got a string in format 'yyyyMMddhhmmssf' (e.g. '2005032314221'), how
can I convert it to date object in reporting services?
Because I would like to show the date in format according to regional
setting of client. After getting the date object, I can make use of
FormatDateTime. Thanks!
Regards,
MandaHi,
In the "Format" property just type g you will get the formated one.
or
Right click the textbox to get the properties. click Format tab and go to
Format code and click "..." select date and the format.
Amarnath
"Manda Ho" wrote:
> If I got a string in format 'yyyyMMddhhmmssf' (e.g. '2005032314221'), how
> can I convert it to date object in reporting services?
> Because I would like to show the date in format according to regional
> setting of client. After getting the date object, I can make use of
> FormatDateTime. Thanks!
> Regards,
> Manda
>
>|||If I would like to show the concat this date field with other message, do I
have to keep the date field under another textbox first?
Thanks!
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:B9EACB56-70B1-4F30-95CE-6BE6E897F228@.microsoft.com...
> Hi,
> In the "Format" property just type g you will get the formated one.
> or
> Right click the textbox to get the properties. click Format tab and go to
> Format code and click "..." select date and the format.
> Amarnath
> "Manda Ho" wrote:
> > If I got a string in format 'yyyyMMddhhmmssf' (e.g. '2005032314221'),
how
> > can I convert it to date object in reporting services?
> >
> > Because I would like to show the date in format according to regional
> > setting of client. After getting the date object, I can make use of
> > FormatDateTime. Thanks!
> >
> > Regards,
> > Manda
> >
> >
> >|||Hi,
Yes since you cannot apply format with other textbox. So keep it seperate
and align it.
Amarnath
"Manda Ho" wrote:
> If I would like to show the concat this date field with other message, do I
> have to keep the date field under another textbox first?
> Thanks!
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:B9EACB56-70B1-4F30-95CE-6BE6E897F228@.microsoft.com...
> > Hi,
> >
> > In the "Format" property just type g you will get the formated one.
> > or
> > Right click the textbox to get the properties. click Format tab and go to
> > Format code and click "..." select date and the format.
> >
> > Amarnath
> >
> > "Manda Ho" wrote:
> >
> > > If I got a string in format 'yyyyMMddhhmmssf' (e.g. '2005032314221'),
> how
> > > can I convert it to date object in reporting services?
> > >
> > > Because I would like to show the date in format according to regional
> > > setting of client. After getting the date object, I can make use of
> > > FormatDateTime. Thanks!
> > >
> > > Regards,
> > > Manda
> > >
> > >
> > >
>
>|||Thanks!
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:3851D293-473D-43AC-953A-EF3D25AF20E0@.microsoft.com...
> Hi,
> Yes since you cannot apply format with other textbox. So keep it seperate
> and align it.
> Amarnath
> "Manda Ho" wrote:
> > If I would like to show the concat this date field with other message,
do I
> > have to keep the date field under another textbox first?
> >
> > Thanks!
> >
> > "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> > news:B9EACB56-70B1-4F30-95CE-6BE6E897F228@.microsoft.com...
> > > Hi,
> > >
> > > In the "Format" property just type g you will get the formated one.
> > > or
> > > Right click the textbox to get the properties. click Format tab and go
to
> > > Format code and click "..." select date and the format.
> > >
> > > Amarnath
> > >
> > > "Manda Ho" wrote:
> > >
> > > > If I got a string in format 'yyyyMMddhhmmssf' (e.g.
'2005032314221'),
> > how
> > > > can I convert it to date object in reporting services?
> > > >
> > > > Because I would like to show the date in format according to
regional
> > > > setting of client. After getting the date object, I can make use of
> > > > FormatDateTime. Thanks!
> > > >
> > > > Regards,
> > > > Manda
> > > >
> > > >
> > > >
> >
> >
> >