Data Shuttle - Need to filter new hires within last 30 days

jahmeanne

Hi everyone,

I'm trying to set up a Data Shuttle offload that will export the following information into OneDrive:

• Employee Name
• Role
• Manager
• Employee Type
• Hire Date

The problem I'm running into is that I am not seeing any viable way to filter the results within the last 30 days. I setup a report for this as well but discovered that there are no automations that can be configured. Could anyone please provide me a viable way to export this data on a scheduled basis?

Jason Tarpinian

You can't have relative dates in the filter section of Datashuttle, but you can build a helper column on your sheet.

So on your sheet you could build something like =IF(AND([Hire Date]>=TODAY(-30),[Hire Date]<=TODAY()),1,0) to check a box for all new hires in the last 30 days. Then in the filter portion on your offload, use that field "equals" "true". Example below is just from a CC sheet I used as example, but something like that.

jahmeanne

Hey Jason,

This is AWESOME! I'm going to try this right now. Thank you so much, I really appreciate you!