Date format.

[Former Member]

how to populate the date field in mm/dd/yyyy format, into an output field, while the data is coming in from RSDDAGGRDIR table in DEC format.

[Former Member]

Hi,

Generally Timstamp data is stored in the format (YYYYMMDDhhmmss) in DEC type.

so declare

data: date(8), and Date1(10)

date = timestamp+0(8). YYYYMMDD

move date to date1 or

write date to date1 in the required format

or separate Day, month ,year separately and concatenate and write.

reward points if useful

regards,

ANJI

[Former Member]

hi Anji,

I am getting the timestmp from RSDDAGGRDIR table into an internal table, and then modifying it, by taking the timestmp value into a variable and then modifying the value in the variable, and then appending the varible into the internal table and populate the output from the internal table.

But, the problem is that the modified variable value is not getting appended to the internal table......

please help me out.......

[Former Member]

Hi,

If your date is coming mm.dd.yyyy like this

Ex : date = 22.03.2007.

CONCATENATE date0(2) '/' date2(4) '/' date+4(8) into date.

Don't forget to reward if useful..

[Former Member]

Hi..

the field is in format..(YYYYMMDDhhmmss) = mm/dd/yyyy

w_date(15) type c.

w_final(10) type c.

w_date = lastupdate.

<b>concatenate w_date4(2) '/' w_date6(2) '/' w_date+0(4) into w_final.</b>

write: w_final.

[Former Member]

Use the WRITE... TO statement.

WRITE <date> TO <output field>.

[Former Member]

Hi Hitesh,

Absolutly agree with Anji solution. You can try with that,

Reply for queries, Shall post you the updates.

Regards.

Kumar. .