Filtering by date in a bespoke table that has no date

Avatar

Avatar
Validate 10
Level 2
thomash82948276
Level 2

Likes

14 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
thomash82948276
Level 2

Likes

14 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
thomash82948276
Level 2

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
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
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)