# Calculate column makes from number a date

**URL:** <https://community.easymorph.com/t/calculate-column-makes-from-number-a-date/6743>\
**Category:** General Q&A\
**Created:** [August 5, 2026, 12:29pm UTC](https://community.easymorph.com/t/calculate-column-makes-from-number-a-date/6743 "2026-08-05T12:29:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rob](https://community.easymorph.com/letter_avatar_proxy/v4/letter/r/838e76/32.png) [@Rob](https://community.easymorph.com/u/Rob)\
**Post date:** [August 5, 2026, 12:29pm UTC](https://community.easymorph.com/t/calculate-column-makes-from-number-a-date/6743/1 "2026-08-05T12:29:18Z")

</div>

Hi,

I am using a calculated column where a numeric value is written to the new column, but it is being interpreted as a date. Please see the attached example.

How can I resolve this issue? Neither the AsNumber function nor the Convert.To... functions seem to work.

 ![2026-08-05_14-21-14](https://community.easymorph.com/uploads/default/original/2X/2/29723e4cceda6189518e7b5e7e51f202286189cb.gif)

---

<div class="post-metadata">

**Author:** ![Den.Onufriiev](https://community.easymorph.com/letter_avatar_proxy/v4/letter/d/a5b964/32.png) [@Den.Onufriiev](https://community.easymorph.com/u/Den.Onufriiev)\
**Post date:** [August 5, 2026, 1:09pm UTC](https://community.easymorph.com/t/calculate-column-makes-from-number-a-date/6743/2 "2026-08-05T13:09:58Z")

</div>

Hi, Rob!  
You can change format of the column to Number by selecting 1000 in this menu (see the example, the first picture shows column with dates, the second picture shows the same column with format transformed to numbers)  
After saving the project the column will keep the number format.

 ![Date_to_number_2](https://community.easymorph.com/uploads/default/original/2X/c/cc3780dc16b8597d7e328125573e800d87ede316.png)

 ![Date_to_number_1](https://community.easymorph.com/uploads/default/original/2X/f/f63842cabb802045408baf4a51fc0c2b71bce19e.png)