>Thanks for your reply...
>It going to be one of these, they are all texts fields
>D2CLNT+D2BTCH+D2SEQN
>D2DATE
>D2UNIT+DTOC(D2DATE)
>D2SEQN
>
>Thanks
>Mark Phillips
This one is wrong (it depends on custom SET DATE/CENTURY settings). See Help on DTOC function for details.
D2UNIT+DTOC(D2DATE)
Should be
D2UNIT+DTOC(D2DATE,1)
or
D2UNIT+DTOS(D2DATE)
If it's not broken, fix it until it is.
My Blog