Filtering by date in a bespoke table that has no date

Avatar

Avatar

thomash82948276

Avatar

thomash82948276

thomash82948276

21-08-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

21-08-2018

Hi Tom,

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

Regards,
Vipul

Answers (0)