Loading...
 

Derived Attribute of a date

For any WikiPlugin that uses Search and List from Unified Index (ex.: very useful in PluginPivotTable but it works in PluginList etc.)

You can customize the date format to show only the date or week or month, not the specific date or time. Ex.:

  • only the day number of the month with %d , or
  • only the day number of the year with %z , or
  • only or the week number of the year with %W , or
  • only the month number with %m , or
  • only the year with %Y , etc

This way, you can get the aggregated values of interest for your report.

Example of code to display only the month number from these dates so that you can draw charts with counts per month, etc:

Copy to clipboard
{display name="creation_date" format="date" dateFormat="%m"} {display name="modification_date" format="date" dateFormat="%m"}


Full list of codes available here:
http://php.net/manual/en/function.date.php

It is similar to this but directly in Tiki. And it's fast because it's done by PHP. It is also similar to Grouped Data.

List Slides
Derived Attribute of a date For any WikiPlugin that uses Search and List from Unified Index (ex.: very useful in PluginPivotTable but it works in PluginList etc.) You can customize the date format to show only the date or week or month, not the specific date or time. Ex.: only the day number of the month with %d , or only the day number of the year with %z , or only or the week number of the year with %W , or only the month number with %m , or only the year with %Y , etc This way, you can get the aggregated values of interest for your report. Example of code to display only the month number from these dates so that you can draw charts with counts per month, etc: Copy to clipboard {display name="creation_date" format="date" dateFormat="%m"} {display name="modification_date" format="date" dateFormat="%m"} Full list of codes available here: http://php.net/manual/en/function.date.php It is similar to this but directly in Tiki. And it's fast because it's done by PHP. It is also similar to Grouped Data .