DATE format

Former Member — Thu, 07 May 2009 16:10:56 GMT

Hi gurus!

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?

Thanks

Re: DATE format

Former Member — Thu, 07 May 2009 16:28:48 GMT

Hi,

Yes you need to write the code to format the date as per your requirement.

Former Member — Thu, 07 May 2009 16:32:31 GMT

Yes.