# Show data for last X days
**URL:** https://meta.discourse.org/t/show-data-for-last-x-days/215810
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [January 24, 2022, 1:59pm UTC](https://meta.discourse.org/t/show-data-for-last-x-days/215810 "2022-01-24T13:59:55Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Amine\_Akkar](https://meta.discourse.org/u/Amine_Akkar)
#### Post date: [January 24, 2022, 1:59pm UTC](https://meta.discourse.org/t/show-data-for-last-x-days/215810/1 "2022-01-24T13:59:55Z")
Hello
I’m trying to run a report how shown the visits during the last 30 days, so I used this query but apparently, it’s wrong :
```plaintext
select distinct user_id, max(visited_at) as visited_at from user_visits
WHERE CAST(visited_at AS DATE) >= GETDATE() -30
group by user_id
```
I tested also this condition
`WHERE CAST(visite d_at AS DATE) >= CAST(GETDATE() -30 AS DATE)`
is it possible to have this kind of conditions ?
Thank you
---
### Author:  [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [January 24, 2022, 2:48pm UTC](https://meta.discourse.org/t/show-data-for-last-x-days/215810/2 "2022-01-24T14:48:06Z")
> [@Amine\_Akkar](#):
>
> a report how shown the visits during the last 30 days
Try
```sql
SELECT
user_id,
COUNT(*) AS visits
FROM user_visits
WHERE visited_at > CURRENT_DATE - 30
GROUP BY 1
ORDER BY 2 DESC
```
---
### Author:  [@Amine\_Akkar](https://meta.discourse.org/u/Amine_Akkar)
#### Post date: [January 24, 2022, 2:52pm UTC](https://meta.discourse.org/t/show-data-for-last-x-days/215810/3 "2022-01-24T14:52:34Z")
thank you @Falco , it works fine
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [February 23, 2022, 2:53pm UTC](https://meta.discourse.org/t/show-data-for-last-x-days/215810/4 "2022-02-23T14:53:05Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.