You’re offline. This is a read only version of the page.
Announcements
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);
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
