Extracting and sorting by year

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.

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

6 Likes

@macastan

Thank you :pray:

1 Like