Date Problem

[Former Member]

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]

HI,

Use the FM CONVERT_DATE_TO_INTERNAL

It will helps u.

Thanks,

Shankar

[Former Member]

translate w_char using '- '.

condense w_char no-gaps.

after - in single quotes space is necessary...

reward helpful answers..

sai ramesh

[Former Member]

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

or

translate date using '- '.

condense date no-gaps.

Regards,

Ravi

[Former Member]

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]

hi

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^