Hello there,
This is my first post even thougn I was reading other messages from a long time. I think its a great forum for anybody who wants information about Ascential products
Let me explain about my question. I am trying to separate date from a date record in 'ddyyyy' format. can anyone expalin to me how to achieve this.
Thanks in advance.
-Yamini
to split date from the date record in DDYYYY format
Moderators: chulett, rschirm, roy
Hi,
converting dates to any givven format has more then 1 way of doing it.
the conventional way:
Use Oconv() and Iconv() to get dates from any format to internal DS format and then back to a format of your choice.
(read the help on ussage of theese routines).
the substring way:
if you have a date format of "2004-29-10" in a column col1 (since it is easily treated as a string)
you can write something like this:
link1.col1[6,2] : link1.col1[1,4]
now you only need to pick and write.
IHTH,
converting dates to any givven format has more then 1 way of doing it.
the conventional way:
Use Oconv() and Iconv() to get dates from any format to internal DS format and then back to a format of your choice.
(read the help on ussage of theese routines).
the substring way:
if you have a date format of "2004-29-10" in a column col1 (since it is easily treated as a string)
you can write something like this:
link1.col1[6,2] : link1.col1[1,4]
now you only need to pick and write.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Re: to split date from the date record in DDYYYY format
Did you perhaps mean 'dddyyyy' format?yaminids wrote:I am trying to separate date from a date record in 'ddyyyy' format.
If so, there is a 'Julian' conversion option for Iconv that would do that for you.-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers