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

Convert date in TEXT format into DATE

(0) Share

Report

Posted on by Sujan Khadka

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

I have the same question (0)

All responses (6)

Answers (0)

Nitin Verma 21,698 Moderator on at

Like (1)

Report

Hi Sujan Khadka ,

Please use below:

yourtextdate := '01/04/2020';

Evaluate(DateTypeVariable,yourtxtdate);

Was this reply helpful? Yes No
Sujan Khadka 80 on at

Like (0)

Report

Hi Nitin Verma,

above answer returns 01/04/20. But my requirement is that I need 01/04/2020. Hope you understood

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

This is the different question, Initially you asked this "I have date 01/04/2020 in text datatype. Now, I want to convert and return to DATE datatype. Is there any solution?" answer of this I have already shared.

Was this reply helpful? Yes No
Sujan Khadka 80 on at

Like (0)

Report

In Message(Format(abc)) suppose I have 01/04/2020 which is in text datatype. After evaluating with date type, my answer would be 01/04/20 which is a date datatype. But my task is to return 01/04/2020 with date datatype.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Please refer below link

docs.microsoft.com/.../ui-enter-date-ranges

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Nitin is right. The current date format displayed on the page depends on the Region of your current system.

So if you want to change '01/04/20' to '01/04/2020', you should change your region first. (About this our Partner cannot specify)

For example,

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No