In one of my upload program I have 3 date fields . These
fields are uploaed througha csv file extract which comes from a different source.
Theer are other fields for dates too which gets uploaded onto the table in the correct format
but these three fields comes into the table in a distorted format . I would like to correct it
to teh proper format. IN my upload program I have a code written for the format of the
date which is coming correct but not for the other three . Will the same apply to the
other dates too to bring it back to teh correct format . I had the data type of the date
fileds for these three fileds as CHAR24 earlier so I didnt ahve to write the code part . Later
I changed these fields to teh DATS type and since then the problem with these dates format have started.
CONCATENATE s_dls-zlic_date+6(4) s_dls-zlic_date(2) s_dls-zlic_date+3(2) iNTO s_dls-zlic_date.
SO do I have to write the format in teh similar way for other z1 filed, z2 field and z3 field also?