News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... how to Convert DATE Da...

Small and medium business | Business Central, N...

Answered

how to Convert DATE Datatype into TEXT DataType ?

(1) Share

Report

Report

Posted on by Satyajit Barik

7

I have date 01/04/2020 in Date datatype. Now, I want to convert and return to TEXT datatype. Is there any solution?

Categories:

Dynamics 365 Business Central

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

YUN ZHU 75,595 Super User 2024 Season 2 on at

Like (2)

Report

how to Convert DATE Datatype into TEXT DataType ?

Hi, if this is related to language encoding, you can try the FormatDate method in the codeunit below. This returns a Text date.

Hope this helps.

Thanks.

ZHU
Ariba Mehdi 160 on at

Like (1)

Report

how to Convert DATE Datatype into TEXT DataType ?

Hi,

Try the following 2 possible solutions:

1. Check System.Format() method from the link shared below:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/system/system-format-joker-integer-integer-method

2. Try using StrSubsNo(). Check the link below the image as well.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/text/text-strsubstno-method

Hope this helps!
Verified answer

Judy Microsoft Employee on at

Like (1)

Report

how to Convert DATE Datatype into TEXT DataType ?

Hi,

To convert a date in the Date datatype to Text datatype in AL, you can use the FORMAT function.

Txt:= Format(Dt);

The reference Document:

FORMAT Function | Microsoft Learn

Best Regards,

Judy

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans