Skip to Content

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

String field to Data coversion

Hi,

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

Regards,

Rajasekar

Former Member
replied

Hi,

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.

Regards,

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