Skip to Content

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

String field to Data coversion


I want to convert the string field to data format.I tried the option cdate(table.field)

but once again it is throwing an error saying"Formula must be string"

so i gave cstr(cdate(table.field)) but i am getting the value as 4/5/2008

but in the db it is 04/05/2008

Any suggestions





You want to convert string value to date value.

You are using cdate function here which would do the job however cstr function again converts it into a text.

Would suggest you to modify the formula like this

if isdate(databasefield) then cdate(database field)

here isdate function will check weather the database field value can be converted to a date value.

Place this formula on report and right click it and click on Format Field.

Under the Date tab select the format as 03/01/1999.

Click OK and it will show the required results and the value returned will be a date value as well.


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