It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Include date in Confluence

Hi!

I'm trying to put in a date into a wiki page. On auto-generated Retrospective pages, there is an excellent date picker. I'd like this on other pages, but I can't figure out how to include it. It's not a macro, and doesn't exist anywhere within the documentation. The only way I've been able to include the same functionality has been to literally copy and paste the date picker to the new page.

See screenshot. Top is what I want. The rest is how hard I'm trying.

8 answers

1 accepted

70 votes
Answer accepted

You can press // to initiate the date picker.

Oh WOW. Where is that documented? I have no idea how I would have found that out. Google Search: Date Picker Confluence and you get nothing.

Feature request - include the date picker under the Macro's list.

Like # people like this

Thank you it works fine. 

I agree with @Felix Sargent, found no documentation for it.

If you're creating a minutes from a meeting template then the "actions" section gives a hint, but otherwise I don't think it's documented.

Like # people like this
Ann Worley Atlassian Team Apr 04, 2017

The documentation is in the product help:

Keyboard shortcuts

The documentation is for // as in you're typing and inline enter // and get the date picker.

This is not what Felix is referring to. In the retrospective (and other) templates there's a lozenge that inserts the current date when you create the document.

Where is that functionality documented? I've been futzing with it off and on with poor results.

@Ann Worley I followed your link. This "//" is not documented there. 

Ann Worley Atlassian Team Sep 22, 2017

Thank you very much for pointing this out! I scoured the keyboard shortcut help pages in both Confluence 6.4 and Confluence Cloud and I did not see the date picker: // shortcut.

Then I found that this has been reported before: Add documentation for date picker keyboard shortcut

Please feel free to comment or vote on the ticket. Doing so will communicate directly with the team responsible for the ticket and also, add you to notifications so you'll know when action is taken on it.

Is there any way to change the date format so after selecting a date the day will be shown for example?

Like Fiona Dempsey likes this

Source says it's

<p>&nbsp;<time datetime="2014-04-25" />&nbsp;</p></td></tr>
but I don't how how to include that.

change the code..never be unsure!

BTW, the "//" as date picker has STOPPED WORKING today!! :(

And today it is working alright!

Like Saumya Sunder[Appfire] likes this

Does anyone know how to format this // date picker? It doesn't seem to follow the settings under general formatting settings as I would have assumed. As described here: https://confluence.atlassian.com/doc/configuring-time-and-date-formats-150144.html

Does anyone know how to format this // date picker?

I find temp solution

<script>
jQuery("time").each(function(index, value){
var element = value;
var mytime = jQuery(element).attr("datetime");
if(mytime != null)
    jQuery(element).html(mytime);
});
</script>

Where can this temp solution be implemented?

I dont think you can. At least not for the "Cloud" version of Confluence. In the "Server" version you can add it as a user-macro.

Two questions

1. When I add that as a user-macro (I have server version).  It does not appear when I type {datepicker}.  How do I get the macro to appear

Note: I entered the exact text below into my macro

<script>
jQuery("time").each(function(index, value){
var element = value;
var mytime = jQuery(element).attr("datetime");
if(mytime != null)
    jQuery(element).html(mytime);
});
</script>

 

2. How do I set the format to be mm/dd/yyyy in that macro?

It might be better to use the solution provided by Milo

https://community.atlassian.com/t5/Confluence-questions/Insert-current-date-in-a-Confluence-template-onDemand/qaq-p/207147#M113878

This way you can change the date output.

(ps, you will have to change the HtmlSpecialChars)

My apologies, I do not know what I would need to change?

And see the other thread, as I had issues in creating the macro itself, in that the macro would not be created if I created the macro 'as is', but that may be due to the fact that I do not know how to 'change the HTMLSpecialChars).

Is it possible to be able to have a date picker available to change the date on the page without having to go into Edit Mode?

Is it possible to enter a specific date using the // format?

I would like to enter // 2008-09-17, but the date picker only seems to allow dates to be entered through the GUI date picker and enter past dates is very cumbersome through this process (can you imagine how many clicks i have to use to enter this date via the date picker without being able to enter it directly?

How can this be a 'feature' if it is not very usable?

How can this be a feature if it has a 'bug' that was just NOW (well 3 weeks ago) entered, and will unlikely be fixed any time soon.

https://jira.atlassian.com/browse/CONFSERVER-55188

Typing

//17/9/2008

works for me.

if it is current year you can do with 

//17/9

The key word there is 'typing'.  Yes that works but I need to 'paste' a date.  I have over 3000 dates that need to be entered (from an excel table) and I want them to use the // date formatter, but pasting the //17/9/2008 does not use the // date formatter it just gets pasted as text >>> //17/9/2008

Update.  I recently discovered that just typing '17-9-2008' (without typing // before this) and then hit enter works.  I am not sure if this is a change or if I never tried this.  But I still need a way to paste dates (or a script that can covert them into the date formatter.

Also, it does occur to me that the date format that I enter 'dd-mm-yyyy' does not match the format that is eventually displayed.  'dd-Mmm-yyyy'.

It is amazing that such a simple feature is 

1. Poorly documented

2. Poorly implemented

Like # people like this

I use the Page Info for Scriptrunner macro to insert created date, last modified date etc on pages.

https://marketplace.atlassian.com/apps/174/page-info-for-scriptrunner-confluence?hosting=server&tab=overview

It's free but I'm pretty sure you need to purchase Scriptrunner to make it function correctly.

Well Scriptrunner is not an affordable option.  Luckily most of the functionality we were using it can now be queried directly in the base product of JIRA/Confluence.

Would this script work on being able to query the Release Date for a Fix Version? (without having Scriptrunner installed?)

0 votes

Thanks for useful answers. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

Introducing Confluence Cloud and Jira Software Cloud Premium

Wherever you are in your team’s journey , our goal is to support your big ambitions. We’re a cloud-first company with the mission of unleashing the potential of every team, and to address the range ...

691 views 5 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you