web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / how to convert integer...
Microsoft Dynamics NAV (Archived)

how to convert integer to text in nav 2016

(0) ShareShare
ReportReport
Posted on by Community Member

Hi experts,

Please tell me how to convert integer to text in nav 2016

Header3:=Header1-AgewseDate; this is integer filed i want to add  ">=" with is filed please tell me how its possible

i have used this code

Integer field := Header1-AgewseDate;

Text filed := '>=' + formate(integer field);

Evalute(header3,Text filed);

 

but getting error like this  can not convert  ">= " as integer.


please give any solution

 

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Andrey Baludin Profile Picture
    Andrey Baludin 3,941 on at

    Hi.

    Evalute(header3,Text filed) - this means that you try to convert text to integer.

    For convert in text you just need to use FORMAT();

    So simply use FORMAT(header3);

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 8,637 Super User 2025 Season 2 on at

    EVALUATE is the standard keyword in NAV which converts almost every data type into the data type in which you want.

    EVALUATE(ConveertToInteger,Text)

    This will convert text into Integer.

  • Community Member Profile Picture
    Community Member on at

    Hi Experts,

    Thank you for both replies i got a solutions.

    Thank you

  • Community Member Profile Picture
    Community Member on at

    To clarify other first time programmers like me:

    1. define a new global or local variable, which is defined as integer; eg. ToInteger

    2. the evaluate function will then be: EVALUATE(ToInteger, 'the strings, functions etc etc that you would like to convert into integer')

    Apparently the evaluate function would try to change the given values to whatever type of data the variable has been defined to be.

    And thank you for previous answers, they led the way!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans