Same here!!!:rolleyes:

You are the man :-)!! Luis

Perfect that's what I was looking for

Hey John,

For 0's,invalid dates it should display nulls

Thanks

SM

got it

=left(Fields!DATE.Value,4)+"/"+mid(Fields!DATE.Value,5,2)+"/"+right(Fields!DATE.Value,2)

give me the result in this format YYYY/MM/DD 🙂

Gsquared,

Thank you for the reply .

I'm new to SSRS, I was under the impression that this could be done in the presentation layer( I could be wrong,cos I'm new to...

Gsquared,

I try to do it your way.

Could you tell me how to go about solving this.

Thanks

Sm

Hi,

Thank you for the reply .

I prefer doing it in the presentation layer instead of doing it in the Database.Is it possible?

Thanks

SM

I mean I want to convert the date field from YYYYMMDD format to MMM/YYYY..

Thank you all of you!!!! Manually looking for similar data seems to be the best solution for my prob!!!

Hi Sean,

I have been told that table A and B are related (2 columns from table A have to be concatenated to form a key ..but I'm...

Thank you Guys !!! I appreciate your help 🙂

Thank you guys,And how to look for tables in a DB lets say any table with the word "SHIPPING"

Regards

SM

Thank you Koen 🙂

Thank you for the promt response Patrick,

Currently I'm creating views which would be mapped to tables in prod server using a ETL tool. Though this particular ETL is capable of...

Well, I'm not authorized to make changes in the original table...so this is the only option I'm left with ;(