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
Former Employee replied
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.