Dear All,

I need to develop report which report should displayed in excel .csv.

for header report,i am using below command (work well)
tcccm.dll0010.append.field(tcccm.dll0010.get.table.field.desc("tfacr200.docd"),delimiter,file.record)

for detail report, i am using below command (work well)
tcccm.dll0010.append.field(num.to.date$(tfacr200.docd,3),delimiter,file.record)

there is new field which i need to display which is if tfacr200.docd = 01022014, i need to display only 02, what is the command that i need to use?

Hi,

Do you mean, you just want the month out of the date?

sprintf$() can give you that in case if you are looking for the same.

e.g.

string result(80)

result = sprintf$("%D(Date: %02d/%02m/%04Y)", date.num())

| result contains "Date: 12/07/1993"

Hence,

To get only month you can use -

string result(2)

result = sprintf$("%D(%02m)", tfacr200.docd)