# Dateformula datatype

**URL:** <https://www.dynamicsuser.net/t/dateformula-datatype/5481>\
**Category:** Developers Forum\
**Created:** [November 9, 2001, 8:56am UTC](https://www.dynamicsuser.net/t/dateformula-datatype/5481 "2001-11-09T08:56:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jordi79](https://avatars.discourse-cdn.com/v4/letter/j/c0e974/32.png) [@jordi79](https://www.dynamicsuser.net/u/jordi79)\
**Post date:** [November 9, 2001, 8:56am UTC](https://www.dynamicsuser.net/t/dateformula-datatype/5481/1 "2001-11-09T08:56:46Z")

</div>

In navision attain 3.01 there is a new datatype called DATEFORMULA. I am not sure what it does but i am having some problems in converting a standard text to this datatype. In previous versions, we just use the CALCDATE function to convert text values to a date value. In short, in the StockKeeping Unit table, there is this field called “Reorder Cycle”, how do i fill in the value of ‘1M’ to this field using C/AL?

---

<div class="post-metadata">

**Author:** ![Bjarne\_Astrup](https://avatars.discourse-cdn.com/v4/letter/b/53a042/32.png) [@Bjarne\_Astrup](https://www.dynamicsuser.net/u/Bjarne_Astrup)\
**Post date:** [November 9, 2001, 2:45pm UTC](https://www.dynamicsuser.net/t/dateformula-datatype/5481/2 "2001-11-09T14:45:32Z")

</div>

You must use EVALUATE to convert text to dateformula and FORMAT to check. EVALUATE(“Reorder Cycle”,’\<1M\>’); The \< and \> is multilanguage enabling and the dateformula must be in english. IF FORMAT(DateFormularField) = ‘’ THEN