Enquiry

I have an app GPS.PAY.DETS.The ID of this app is like 123*AC*1234*20110101.
Now i need to give last part of ID i.e date as a selection field through build routine.Can it be possible?

Pls can any one tell how to do it.

Thanks in advance.

Just say you have the ID in a variable like
Y.ID = 123*AC*1234*20110101
then to extract the date part in the ID you can do the following

Y.DATE = Y.ID[8] ; * This will extract the last 8 chars from the variable Y.ID

(or)

DCOUNT(Y.ID,'*',4)

both the options will fetch you the date..