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)

Suggested answer

YUN ZHU 91,036 Super User 2025 Season 2 on at

Like (0)

Report

RE: Convert date in TEXT format into DATE

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

Nitin Verma 21,627 Moderator on at

Like (0)

Report

RE: Convert date in TEXT format into DATE

Please refer below link

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

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

Like (0)

Report

RE: Convert date in TEXT format into DATE

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

Like (0)

Report

RE: Convert date in TEXT format into DATE

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

RE: Convert date in TEXT format into DATE

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
Nitin Verma 21,627 Moderator on at

Like (1)

Report

RE: Convert date in TEXT format into DATE

Hi Sujan Khadka ,

Please use below:

yourtextdate := '01/04/2020';

Evaluate(DateTypeVariable,yourtxtdate);

Was this reply helpful? Yes No