load current year

[#1]

Hi Experts

I have the following expression:

resident job where Gesellschaft = 'DC' AND Jahr=2014 group by jobnr;

How can I insert the current year instead of hardcoding it?

Thank you for your help!

Jan

[Colin-Albert · Accepted solution]

year(today()) will return the current year

where Gesellschaft = 'DC' AND Jahr=year(today())

group by jobnr;

[Gysbert_Wassenaar]

resident job where Gesellschaft = 'DC' AND Jahr=Year(today()) group by jobnr;

[#4]

merci