Hi friend,

i want it before s before 12:00 AM GMT on June 3, 2013.

can i use it as -

[WorkForce_JobPosting].[Job Posting Create Date_JP] < '2013-06-03'

?

thanks

Dhananjay

What I'm asking for is how to use CASE syntax for these validations?

Thanks to all of you here for helping me, gave me some idea ... and I rewrote the code and now seems Im seeing the results the user expects-

CAST...

Thanks Lynn it worked 🙂 you are awesome.

No worries Lynn i was able to resolve it.

Sorry I bothered you for this

thanks

DJ

The code is working good for me 🙂

thanks

Dhananjay

I'm new to TSQL , but per my requirement I used this logic- feel free to suggest me if anything better .

I'm open to suggestions 🙂

thanks

Dhananjay

Sure I would love to share-

Here's what I did-

created 3 temp tables with the filelds I need for each with same order, data type.

then UNION the 3 selects.

then in...

No worries, I was able to resolve this 🙂

Kind Regards

Dhananjah

Thanks so much for help. it worked.

Kind Regards

Dhananjay

Hi Craig,

The FORMAT in SSRS did not work - I lost the value .

But here's what I did I right clicked the field , then in the Text Box Properties...

Hi Eric,

The suggestion of usinf FORMAT tried but somehow when I used FORMAT for the field value then the field lost value, hence what I did is right clicked the...

Hi Craig,

I use SSRS 2008 visual studio where in i invoke my SP ..

The report is then download in excel ..by user

Thanks

DJ

Hi Craig,

since I do not want to lose the date in the Report hence seems the best suggestion is in DB to do this change instead of DATE TIME STAMP...

Thanks Lakhan.

It realy helped me .

Kind Regards

Dhananjay