News and Announcements icon

Dynamics 365 CommunityForums Business Central forum how to Convert DATE Da...

Business Central forum

Answered

how to Convert DATE Datatype into TEXT DataType ?

(1) Share

Report

Report

Posted on by Satyajit Barik

22

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

Categories:

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

YUN ZHU 68,480 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 156 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... 290,263 Super User 2024 Season 2

#2

Martin Dráb 228,112 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans