Sales managers wanted a report to analyze all sales activities performed in the last 30 days and want
to have the report available so they can run it every month. Which of the following represents the
correct?
A.
CAST (TIMESTAMPDIFF (SQL._TSI_DAY, 30, CURRENT_DATE) as datE.
B.
TIMESTAMPADD (SQL_TSI_DAY, -30, CURRENT_DATE)
C.
CAST (TIMESTAMPDIFF (SQL_TSI_DAY, -30, NOW ( )) as timestamp)
D.
CAST (TIMESTAMPADD (SQL__TSX_DAY, -30, CURRENT_DATE) as datE.
E.
TIMESTAMPADD (SQL_TSI_DAY, -30, CURRENT_DATE) as timestamp
Explanation:
The CURRENT_DATE function returns the current date that you run your report. This allows you to
include a variable date in your report so that your report is based on the date that the report runs.
The CURRENT_DATE value does not contain a time component. The report filter uses the
TIMESTAMPDIFF function to limit the number of days between lead creation and the last data
refresh.