Filtering by date in a bespoke table that has no date | Community
Skip to main content
thomash82948276
Level 2
August 21, 2018
Solved

Filtering by date in a bespoke table that has no date

  • August 21, 2018
  • 1 reply
  • 1729 views

I'm trying to create a query containing everyone who did a certain action on our website.

That data is in its own schema.  Unfortunately, there is no date written to that schema as to when this action happened.

Is there a system date that I can use (Date Record Added or something) to filter on this value?  I only need the query to contain these actions from the last 3 days.  Currently the query is taking a long time to load as it's pulling in everyone who did the action.

Thanks, Tom

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by vraghav

Hi Tom,

You need to have a date column explicitly added if you wish to make this kind of query

Regards,
Vipul

1 reply

vraghav
Adobe Employee
vraghavAdobe EmployeeAccepted solution
Adobe Employee
August 22, 2018

Hi Tom,

You need to have a date column explicitly added if you wish to make this kind of query

Regards,
Vipul