A lot of my report are in ddmmyyyy format

Suppose my field srv.dt = 01062011.

How do i use sprintf$ field to convert it into yyyy/mm/yy

thank you

A lot of my report are in ddmmyyyy format

Suppose my field srv.dt = 01062011.

How do i use sprintf$ field to convert it into yyyy/mm/yy

thank you

Hello,
have a look at this thread:

http://www.baanboard.com/baanboard/showthread.php?t=60207&highlight=sprintf%24

Regards

A lot of my report are in ddmmyyyy format

Suppose my field srv.dt = 01062011.

How do i use sprintf$ field to convert it into yyyy/mm/yy

thank you

Hello,
do not post the same twice, please.

Regards

Hi,
Try to use
result=sprintf$("%D(Date: %04y/%02m/%02d)",srv.dt) and search in programming manual for further clarifications.