Adding Current Year As Filter

General
#1

Hello Team Helical,

I am using Helical Insight Enterprise Version. I want to add the current year as the filter for a report. How can I do this?

Thank You
Priya

1 Like
#2

Hello Tarun,

Please follow the below mentioned steps to add current year as filter:

  1. Add the date column as filter.

  2. Go to Edit (pencil icon).

  3. In Condition, select Custom

  4. In Custom Condition, enter =year(current_date()). Please note that the formula will change from database to database. This formula will basically fetch the current year and pass that to that column.
    image

  5. In Values field press space bar and give a space. Save the filter and generate the report.
    Similarly, you can create other date conditions.

Thank You
From Team Helical