Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Scripting a field for a date

I am reading a very old data field that is stored as a number however it is realy a date field. when you look at it, it appears as 20,080,912.00 and its real value is 09/12/2008 any suggestion on how to script this from the old to the required date?

Any help is appricated.

Jim

replied

Sorry, my bad, I forgot to convert the strings back to numbers. Add tonumber to numbervar y:= tonumber(mid(a,1,4)); . You will have to add that to the other 2 variables as well.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question