Post a question

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 ?

Like (1) Share

Report

Report

Posted on 2 Feb 2024 06:14:32 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

Judy Microsoft Employee on 02 Feb 2024 at 09:47:22

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
Verified answer

YUN ZHU 80,823 Super User 2025 Season 1 on 05 Feb 2024 at 00:36:50

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

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,757 Super User 2025 Season 1

#2

Martin Dráb 232,722 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans