Date Issue

Good Afternoon,

I have a late shipment report, I added a field where it give me information whether a shipment is late or. This is what I have so far.

=DateDiff("d", Fields!SHIP_DATE.Value ,Fields!PROMISE.Value)

It is doing what I want it to do, except one problem, I need it to display only the ones that are late, not all of them. I tried sorting it our with

=DateDiff("d", Fields!SHIP_DATE.Value ,Fields!PROMISE.Value) < 0

But it gives me an error or it wont accept the sorting.

I'm all ears....please help.

Abner

why dont you modify your SQL query itself instead of doing it from report

Select * from OrderTable where DATEDIFF(day, SHIP_DATE, PROMISE ) < 0

|||

rmaiya, thanks for the reply but I got it. The way I had it first was right, but had to do the sort under group properties, visibility and add my new field (where the expression was added) and add <= 0 and it works like a charm.

abner