Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Filtering by date in a bespoke table that has no date

thomash82948276
Level 3
Level 3

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

1 Accepted Solution
Vapsy
Correct answer by
Employee
Employee

Hi Tom,

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

Regards,
Vipul

View solution in original post

1 Reply
Vapsy
Correct answer by
Employee
Employee

Hi Tom,

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

Regards,
Vipul

View solution in original post