It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
What is the exact syntax for formatting dates in a table (using Excel Macro), or what is the trick?. I can not get it to work at all.
My Excel content has column 1 as the date. The date is formatted in Excel as DD/MM/YYYY. In the wiki page I only want it to show as MMM-YYYY and be sortable so it sorts in date order.
Here is what I have tried.
Any ideas that can help?
Yes, you need the date.js file installed correctly for any Advanced date sorting. Specifically in .../includes/js. However, there is no data converted - you are just telling the macro the format of the field for sorting purposes.
Thanks for that answer Bob, so I gather then that there is no way to re-format the data at all between the display in Excel and the display in the page.
My answer is that I will have to display the date as MM-YYYY in Excel, install the date.js then set the Date format for the sort.
It all makes sense when you know how :).
Thanks
I think I may have answered my own question. Is the date formatting of DMM-yyyy etc only available if you install the date.js file on the server? I think I have tried that previously on another server and not had much luck with it.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.
Read moreHi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
Connect with like-minded Atlassian users at free events near you!
Find a groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.