Formula for annual and semester filter

[#1]

Hi!

I'm trying to insert a formula that filters data by year and semester.

I tried Year([Data BACENJUD]) AS [ANO BACENJUD] for year but I can't find the right one for semester.

Does anyone know how to do that?

Thank you for your help!

[alexandros17]

If(Month([Data BACENJUD]) <=6, 'H1', 'H2') as Sem

[#3]

Alessandro,

What's the H1 and H2 for? Because I did it and the filter is not displaying any semesters of the years of the data.

Thank you for your help?