Hi,
I am getting date fields actually text fileds with various formats MM/DD/YY and YY/MM/DD . I need convert them to DD/MM/YYYY.
Please can any body tell the functions need to be used in converting date format and check the date ISv alid
How to convert date foramts to other formats
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Re: How to convert date foramts to other formats
What is your target, change of format only makes sense if your target is sequential filee1994264 wrote:I need convert them to DD/MM/YYYY.
There are no functions to change the format of date value that exists in text form. you need to take substrings and concatenate them to fit your requiremente1994264 wrote:Please can any body tell the functions need to be used in converting date format and check the date ISv alid
ex - yyyy-mm-dd to DD/MM/YYYY
X[9,2]:'/':X[6,2]:'/':X[1,4]
- Zulfi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: