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
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.