https://communities.sas.com/t5/SAS-Programming/Calculated-item-to-get-date-format/m-p/920425#M362506 <P>Duplicate question. Please reply at&nbsp;<A href="https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-builder-Add-date-value-year-instead-of-numeric-value/td-p/920389/jump-to/first-unread-message" target="_blank">https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-builder-Add-date-value-year-instead-of-numeric-value/td-p/920389/jump-to/first-unread-message</A></P> Fri, 15 Mar 2024 13:23:26 GMT PaigeMiller 2024-03-15T13:23:26Z https://communities.sas.com/t5/SAS-Programming/Calculated-item-to-get-date-format/m-p/920412#M362503 <P>Hi,</P><P>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".&nbsp;</P><P>&nbsp;</P><P>TreatAs(_Date_, 'Jaar'n)</P><P>&nbsp;</P><P>What am I doing wrong? Or is there a different way how I can convert this numeric value to a date?</P><P>&nbsp;</P><P>Many thanks in advance!</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 15 Mar 2024 12:39:39 GMT https://communities.sas.com/t5/SAS-Programming/Calculated-item-to-get-date-format/m-p/920412#M362503 user34567 2024-03-15T12:39:39Z https://communities.sas.com/t5/SAS-Programming/Calculated-item-to-get-date-format/m-p/920425#M362506 <P>Duplicate question. Please reply at&nbsp;<A href="https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-builder-Add-date-value-year-instead-of-numeric-value/td-p/920389/jump-to/first-unread-message" target="_blank">https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-builder-Add-date-value-year-instead-of-numeric-value/td-p/920389/jump-to/first-unread-message</A></P> Fri, 15 Mar 2024 13:23:26 GMT https://communities.sas.com/t5/SAS-Programming/Calculated-item-to-get-date-format/m-p/920425#M362506 PaigeMiller 2024-03-15T13:23:26Z