Currently in the charts and graphs, dates (specifically when grouping by weeks) show as something like 2015-W48 (for the 48th week of the year). It would be much more informative if you could choose to display the first or last date of the associated week instead. Typically, someone wouldn't know which week the 48th week is referring to but if it showed 11/23/2015 they would. Perhaps this is accomplished via an additional dropdown for choosing the date format when configuring the charts and graphs.
Thanks!!
Clint,
There is currently a Change Request already in the pipeline for the date format to be configurable. There is currently no ETA on the availability of this functionality but the request ID is CR-259564
Please sign in to leave a comment.
Hi,
About this feature, is there any built in datetime formater function that we can use in report formulas ?
In order to just show a Month name, I had to write this awesome code snippet in the formula are :D
I am not proud of sharing such a snippet but maybe it will be useful for some other Clarizen users.
If(Month($CreatedOn)=0,"January",
If(Month($CreatedOn)=1,"February",
If(Month($CreatedOn)=2,"March",
If(Month($CreatedOn)=3,"April",
If(Month($CreatedOn)=4,"May",
If(Month($CreatedOn)=5,"June",
If(Month($CreatedOn)=6,"July",
If(Month($CreatedOn)=7,"August",
If(Month($CreatedOn)=8,"September",
If(Month($CreatedOn)=9,"October",
If(Month($CreatedOn)=10,"November",
If(Month($CreatedOn)=11,"December","")
)))))))))))