how can i covert text into dateformula?

Business Central/NAV User Forum
1

How can i convert text into datetime>

Microsoft Dynamics NAV

Type conversion is not possible because 1 of the operators contains an invalid type.

DateFormula := Text

OK

thanks in advance.

2

Hi Smnehal,

Use FORMAT to convert “something” into text…
e.g.
TextVar := FORMAT(DateFormulaVar);

Use EVALUATE to convert text into "something…
e.g.
EVALUATE(DateFormulaVar,TextVar);