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?
Yes you need to write the code to format the date as per your requirement.