Display current date in Canvas Workpad

[Matheus_Rodrigues]

Hello,

I want to display the current day in text format on my Canvas Workpad, e.g.: 05th, December, or something like that. Do you have any ideas on how I can do it? FYI the date information is in the @timestamp field.

Thanks

[Priscilla_Parodi]

Hello @Matheus_Rodrigues, welcome to the community!

Given that you have this date stored in a timestamp field, one way to display the most recent timestamp is to use a text element (add element -> text), then open the expression editor and add something like this:

filters
| essql
query="SELECT timestamp as date FROM \"kibana_sample_data_logs\"
ORDER BY timestamp DESC
LIMIT 1"
| markdown "Date: {{#each rows}}{{date}}{{/each}}"
| render