Employees Hired in the Last 7 Days

Content

Hi Guys,

I'm trying to generate a report to show employees who were hired in the last 7 days. I've created a Data model and basically inserted this statement into the model, but I  an error saying 'Failed to load SQL': Any ideas?

TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE)

Full query below:

 

select "Worker"."Person Number" as "Person No",

"Worker"."Employee Name" as "Employee",

"Worker"."Person Start Date" as "Start Date",

"Worker"."Employee Date Of Birth" as "DOB",

"Worker"."Manager Name" as "Manager",

"Person Email Addresses"."Email Type" as "Email Type",

"Person Email Addresses"."Email Address" as "Email",

"Person Phones"."Phone Type" as "Phone Type",