How to get all users that signed up in the last 30 days? I suppose I need some builtin SQL function to generate this date format and then do -30 days. I’ve tried a few examples from the Interwebz, such as this , but I get a syntax error. WITH query_period AS ( SELECT date_trunc('month', CURRENT_DATE…

Got it. SELECT username FROM users WHERE created_at >= CURRENT_TIMESTAMP - INTERVAL '30 days' AND staged = false

SQL query for last created users of the past 30 days

pfaffman (Jay Pfaffman) August 15, 2022, 2:56pm 2

1 Like

Topic		Replies	Views
SQL query for users who have posted on a date (or date range) data & reporting sql-query	8	1318	July 11, 2021
Active users in the last 30 days data & reporting sql-query	3	188	September 5, 2016
Run a query based on a timeframe data & reporting sql-query	2	234	June 21, 2023
New users within the past week (formatted usernames) data & reporting sql-query	2	80	January 18, 2018
Users Last Seen Since (Since N Days Ago) data & reporting sql-query	0	113	May 1, 2016