Compairing Dates - RS

[toray]

Hi,

I am using Reporting services to write a report from an oracle database and I need to compare two dates, a date extracted from Oracle and the System date (SYSDATE).

First i need to subtract 7 days from the sysdate, and the solution should be sysdate-7 but this gives me an error 'you entry cannot be converted to a valid date time value'

Once I have acheived this I then need to compare the Oracle date.

eg Oracle Date < (sysdate -7) . Can someone please help?



Regards,



Gary Shaw

 

[xlbo]

If you can do this in SQL, I would do it there - otherwise you will have to faff around with VB expressions to convert a date to an integer, then add a number to it, then convert back to a date to be able to compare it to another date

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question