Hyperion Financial Reporting Products (MOSC)

MOSC Banner

Limit-7 Day Date Selection

edited Mar 23, 2012 5:29AM in Hyperion Financial Reporting Products (MOSC) 1 commentAnswered
I am trying to use the limit line to select only rows with dates within the past 7 days.  Here is the custom SQL I tried:

$DB.Travel_Date  > (CURRENT_DATE  - 7 days)

 

Travel_Date is a field on my $DB table and “CURRENT_DATE -7 days” works on my request line.  The error I get is:

 

[Teradata](ODBC Teradata Driver)[Teradata Database]

Syntax error: expected something between an integer and the word ‘days’.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center