Calculated item to get date format

[user34567]

Hi,

I would like to convert a numeric value to a date value (2024). When I use the following query I get output date "1965" instead of "2024". 

TreatAs(_Date_, 'Jaar'n)

What am I doing wrong? Or is there a different way how I can convert this numeric value to a date?

Many thanks in advance!

[PaigeMiller]

Duplicate question. Please reply at https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-builder-Add-date-value-year-instead-of-num...