Share
ReportI have date 01/04/2020 in text datatype. Now, I want to convert and return to DATE datatype. Is there any solution?
Categories:
You’re offline. This is a read only version of the page.
80
I have date 01/04/2020 in text datatype. Now, I want to convert and return to DATE datatype. Is there any solution?
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
Please refer below link
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.
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.
Hi Nitin Verma,
above answer returns 01/04/20. But my requirement is that I need 01/04/2020. Hope you understood
Hi Sujan Khadka ,
Please use below:
yourtextdate := '01/04/2020';
Evaluate(DateTypeVariable,yourtxtdate);
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,564
Super User 2024 Season 2
#2
Martin Dráb
228,651
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (