Filter on date

[Tridev_Dev]

I have data in a date field, Filtering must be applied to that field, According to logic, each run must choose values from the current year. For instance, if data contains future values, it should disregard them and choose numbers from the current year.

[BS_THE_ANALYST · Accepted solution]

datetimeparse([YOUR DATE FIELD HERE], "%Y") = datetimeparse(datetimetoday(), "%Y")

[Qiu]

@Tridev_Dev 
It will be better you can provide a sample input and desired output. 😁

[Tridev_Dev]

Thank you for helping out; it was very helpful.