Microsoft Dynamics NAV (Archived)

Concatenate a Date and Text into a Text Variable

(1) Share

Report

Posted on by edwardl

This is what I want to do:

PeriodText := 'As at: ', EndDate

This is what PeriodText is:

PeriodText is a Text DataType and has a length of 25.

This is my error:

Error: Type conversion is not possible because 1 of the operators contains an invalid type. Text := Date

Is there a way to convert, cast, concatenate the date type into/with the string and then assign it to the text datatype? I would accept the possibility of only assigning a type casted EndDate to it.

Also, I cannot change PeriodText to a date type because it is used in other locations outside of my IF statement.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (4)

Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Edward

Try this

PeriodText := 'As at: ' + FORMAT(EndDate);

Just FYI FORMAT function is used to convert other data types into text.

Was this reply helpful? Yes No
Verified answer

mmv 11,471 on at

Like (0)

Report

Hi,

As you are trying to concatenate Date datatype and Text, you are getting the error. As mentioned by Suresh, you need to use the FORMAT function while concatenating with different datatypes with text.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

Function you are looking for is FORMAT. FORMAT function Formats a value into a string.

To learn more about format function refer this link.

As suresh mentioned you can use following code line.

PeriodText := 'As at: ' + FORMAT(EndDate);

Was this reply helpful? Yes No
Verified answer

edwardl 2 on at

Like (0)

Report

Here is the code that I settled on:

IF "Acc. Schedule Line".GETRANGEMIN("Date Filter") = "Acc. Schedule Line".GETRANGEMAX("Date Filter") THEN

PeriodText := 'As at: ' + FORMAT(EndDate)

ELSE PeriodText :=

AccSchedManagement.BuildFinPerDescription(

AccScheduleName."Financial Period Description",StartDate,EndDate);

Was this reply helpful? Yes No