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?
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