topic Re: Date Problem in Application Development and Automation Discussions

Date Problem

Former Member — Thu, 08 Mar 2007 08:11:38 GMT

Hi Experts,

I have Date Field in char(10) format..i.e 2007-06-03.

Now i want to remove this extra '-' or '.'. How to do this.( i need this: 20070603)

Thanks in advance.

p291102 — Thu, 08 Mar 2007 08:12:38 GMT

HI,

Use the FM CONVERT_DATE_TO_INTERNAL

It will helps u.

Thanks,

Shankar

Former Member — Thu, 08 Mar 2007 08:12:58 GMT

translate w_char using '- '.

condense w_char no-gaps.

after - in single quotes space is necessary...

reward helpful answers..

sai ramesh

Former Member — Thu, 08 Mar 2007 08:13:39 GMT

replace all occurances of '-' in date with ''.

translate date using '- '.

condense date no-gaps.

Regards,

Ravi

Former Member — Thu, 08 Mar 2007 08:19:29 GMT

try this


data : cdate(10) type c value '2007-06-03',
       ndate(10) type n.

       ndate = cdate.

shift ndate left deleting leading '0'.
cdate = ndate.

it will only take numeric value dont bother about separator whether it is '.' or '-'.

regards

shiba dutta

Former Member — Thu, 08 Mar 2007 08:32:59 GMT

good

store each value into a string and at the end use CONCATENATE statement to join all the values except '-' and display that.

Thanks

mrutyun^