Extracting and sorting by year

[Tritonos_Gruppe]

Hi

I am trying to create a slice that will only show rows from this year not the previous.

Have tried this with no luck, tought this was the way but nope.
How could I also extract only year from this?

([Date]=YEAR(TODAY())))

Greatfull for all help.

[macastan · Accepted solution]

Hi Daniel,

You want to compare YEAR from your column Date and YEAR from TODAY(). You can do this with:

(YEAR([Date])=YEAR(TODAY()))

Hope this helps – you can also reference this documentation which has helpful tips on Date and Time Expressions.

Maria

[Tritonos_Gruppe]

@macastan

Thank you