Display date as year only in query results

Steps to create a query to show only year as a column

1. Click on the ‘Create’ button on the query list page

2. Add any filter for the specimens, collection status equals collected is added for this example

   Open

   

3. Next, click on the temporal expression icon and add the date format as mentioned below -date_format(Specimen.spmnCollRecvDetails.collTime, "%year4%") >1990 and add a description.

   Open

   

4. In the columns, select the new temporal expression field as shown in the screenshot below

   Open

   

5. In the query results page, the collection date will only show the date in YYYY format.

Open