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,790 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,790 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,790 Moderator on at

Like (0)

Report
Copy link

Link copied!

Please refer below link

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,773 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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