Compairing two dates - Reporting Services

• it-261602

  Newbie

  Points: 3

  More actions

  July 11, 2006 at 6:54 am

  #173160

  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

• Gloriann

  Ten Centuries

  Points: 1192

  More actions

  July 12, 2006 at 4:30 pm

  #648848

  If your doing this within reporting services it would be:

  Oracle Date < (today - 7)