Limit-7 Day Date Selection
$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’.