# ESQL for Current Month
**URL:** https://discuss.elastic.co/t/esql-for-current-month/309915
**Category:** Kibana
**Tags:** canvas
**Created:** [July 18, 2022, 2:25pm UTC](https://discuss.elastic.co/t/esql-for-current-month/309915 "2022-07-18T14:25:04Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@karnamonkster](https://discuss.elastic.co/u/karnamonkster)
#### Post date: [July 18, 2022, 2:25pm UTC](https://discuss.elastic.co/t/esql-for-current-month/309915/1 "2022-07-18T14:25:05Z")
Hi,
I need to get data on the Canvas for current month only.
Can someone help with the SQL query on Canvas similar to the KQL below.
`@timestamp > "now/M" and @timestamp <= "now"`
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [July 19, 2022, 7:23am UTC](https://discuss.elastic.co/t/esql-for-current-month/309915/2 "2022-07-19T07:23:39Z")
This should work:
```auto
WHERE timestamp > DATE_TRUNC('month', NOW()) and timestamp <= NOW()
```
> **[Date/Time and Interval Functions and Operators | Elasticsearch Guide \[8.3\] |...](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-datetime.html#sql-functions-datetime-trunc)**
---
### Author:  [@karnamonkster](https://discuss.elastic.co/u/karnamonkster)
#### Post date: [July 19, 2022, 9:33am UTC](https://discuss.elastic.co/t/esql-for-current-month/309915/3 "2022-07-19T09:33:58Z")
> [@flash1293](#):
>
> `WHERE timestamp > DATE_TRUNC('month', NOW()) and timestamp <= NOW()`
Thanks a ton 😉 😃
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 16, 2022, 9:34am UTC](https://discuss.elastic.co/t/esql-for-current-month/309915/4 "2022-08-16T09:34:18Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.