# Canvas display current date

**URL:** <https://discuss.elastic.co/t/canvas-display-current-date/246068>\
**Category:** Kibana\
**Created:** [August 24, 2020, 7:47am UTC](https://discuss.elastic.co/t/canvas-display-current-date/246068 "2020-08-24T07:47:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![probson](https://avatars.discourse-cdn.com/v4/letter/p/e47c2d/32.png) [@probson](https://discuss.elastic.co/u/probson)\
**Post date:** [August 24, 2020, 7:47am UTC](https://discuss.elastic.co/t/canvas-display-current-date/246068/1 "2020-08-24T07:47:31Z")

</div>

Hi,

I am looking to put the current date in to canvas for our reports, any ideas how i could do this?

Thanks

---

<div class="post-metadata">

**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\
**Post date:** [August 24, 2020, 8:41am UTC](https://discuss.elastic.co/t/canvas-display-current-date/246068/2 "2020-08-24T08:41:20Z")

</div>

Hi,

You can add `Time filter` element, from the list of elements.

---

<div class="post-metadata">

**Author:** ![probson](https://avatars.discourse-cdn.com/v4/letter/p/e47c2d/32.png) [@probson](https://discuss.elastic.co/u/probson)\
**Post date:** [August 24, 2020, 8:42am UTC](https://discuss.elastic.co/t/canvas-display-current-date/246068/3 "2020-08-24T08:42:47Z")

</div>

Hi @majagrubic,

I am already filtering the report, i need to display the current date on the report.

---

<div class="post-metadata">

**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\
**Post date:** [August 24, 2020, 9:40am UTC](https://discuss.elastic.co/t/canvas-display-current-date/246068/4 "2020-08-24T09:40:43Z")

</div>

Depending on the format of your data, you can use a Markdown widget and an ES query to fetch the latest timestamp from your documents. That would require that you have documents with today's date in your ES data.

You can then do something like this:

1. Add a markdown (Text) widget
2. Select `Elasticsearch SQL` as data source
3. Open expression editor
4. Write a SQL query along the lines of:

```auto
filters
| essql 
  query="SELECT timestamp as CurrentDate FROM \"kibana_sample_data_flights\"
 ORDER BY timestamp DESC
 LIMIT 1"
| markdown "Current date is {{#each rows}}{{CurrentDate}}{{/each}}"
| render

```

---

<div class="post-metadata">

**Author:** ![probson](https://avatars.discourse-cdn.com/v4/letter/p/e47c2d/32.png) [@probson](https://discuss.elastic.co/u/probson)\
**Post date:** [August 24, 2020, 10:08am UTC](https://discuss.elastic.co/t/canvas-display-current-date/246068/5 "2020-08-24T10:08:58Z")

</div>

@majagrubic

Thats perfect, got that working

---

<div class="post-metadata">

**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\
**Post date:** [August 24, 2020, 10:21am UTC](https://discuss.elastic.co/t/canvas-display-current-date/246068/6 "2020-08-24T10:21:16Z")

</div>