How to show today's date in confluence page

[maziar ebrahimi]

Dear Community,

I'm trying to make a management report and for that need to show on the report always the date of today. How can I do that in Confluence? 

[Katerina Kovriga {Stiltsoft}]

Hi @maziar ebrahimi ,

If your company uses our Table Filter and Charts for Confluence app (you may try to find its Table Filter or Pivot Table macros in the macrobrowser to check), you may use the Table Transformer macro to show the current date using the NOW() SQL function.

SELECT FORMATDATE(NOW())
AS 'Today is'
FROM T*

[Fabio Racobaldo _Herzum_]

Hi @maziar ebrahimi ,

welcome to the Atlassian community!

you can implement your own macro that shows the current date in a page. (https://gebsun-confluence.atlassian.net/wiki/spaces/RTC/pages/17367055/Date+and+datetime+macros)

Hope this helps,

Fabio

[maziar ebrahimi]

Dear Fabio thanks for your quick reply. I'm using Server version which doesn't have the macros. s there anyway to create these macros in Confluence server? BR, Maziar

[maziar ebrahimi]

I'm trying to always show the current day, like today shows Oct 10th tomorrow shows Oct 11th and on

[Balaji Shriram Murkute]

Hi @maziar ebrahimi 

you can directly use Date Macro

There are two ways add Current date in confluence page

1) You can Press  /date

2)You can Press //

and select current Date.

[Shadi Shahsavani]

Date doesn't change every day to the current date, does it?
For me it just shows the same date - date of addition of the formula. 
Like Maziar, I would need to show today's date, ie that the date updates to the current day.

[G subramanyam]

Hi @maziar ebrahimi welcome to the Atlassian community.

Their are 2 ways to add the date macro or use it for your Confluence purpose.

1. Content by label Macro : Add a Content by Label macro to your page to display a list of pages, blog posts or attachments that have particular labels

OR

2. Configuring Time and Date Formats: You can change how times and dates appear throughout your Confluence site to suit your organization's preferred date format.