Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
If(Month([Data BACENJUD]) <=6, 'H1', 'H2') as Sem
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?