Converting Text to Date

attardcattardc Member Posts: 97
I have a text field which contains data in the form of a date (e.g. 12/12/07) and I'd like to convert it or copy it into another variable of the type Date.

I'm using MS Dynamics NAV 5.

Any help appreciated!

Comments

  • MalajloMalajlo Member Posts: 294
    evalute(DateField,TextField)
    
  • attardcattardc Member Posts: 97
    How can I convert the text variable back to a date then?
  • MalajloMalajlo Member Posts: 294
    Use EVALUATE functionalitiy...
    See code before
  • WaldoWaldo Member Posts: 3,412
    Malajlo wrote:
    evalute(DateField,TextField)
    

    Evaluate(DateVariable, TextVariable);

    will work better :wink:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.