Converting Text to Date

albertbuigues

Hi, can anyone say to me if it's possible to convert Text Data to a Date Data? I'm importing a CSV text file to headers and lines and I want to pass one information to the Order Date date field.

Thanks!

Aluan

Hello albertbuigues,
you can use the EVALUATE Function.
See here:
-> https://docs.microsoft.com/en-us/dynamics-nav/evaluate-function

There is even an example with Text to Date.

albertbuigues

If the return value is true, then no errors occurred during the evaluation of the string and the value was assigned to Variable

Didn't see this when I read the manual Evaluate entry thanks!