Type conversion error for DateFormula

liizz

Hello all,

How to modify a field which is of DateFormula datatype?

Am getting this error 'Type conversion is not possible. DateFormula:=Text'.

Infact, I have done a SETFILTER on that field and using the MODIFYALL afterwards.

Thanks

Liizz

mohana_cse06

Can you show your code and explain the requirement please?

David_Singleton

liizz wrote:

Hello all,

How to modify a field which is of DateFormula datatype?

Am getting this error 'Type conversion is not possible. DateFormula:=Text'.

Infact, I have done a SETFILTER on that field and using the MODIFYALL afterwards.

Thanks

Liizz

You will need to use the EVALUATE command, you can't directly assign text to dateformula

so


MyText := FORMAT(MyDateFormula);
Will get the DateFormula as text

and

if evaluate(MyDateFormula,MyText) then
;
Will convert text to DateFormula.
Should work.
...

lakshmivalluru

Basically, you can use SETFILTER on dateformula data type.
you have to do it as david said for each record.

But if we are talking about 100's of records, the best thing will be add a text field to the table. when you assign a value to dataformula field, convert it into text and assign it to text field. so in code you can filter on this text field and modify all records.

liizz

Ok.

I will try it out.

Liizz

liizz

lakshmivalluru wrote:

But if we are talking about 100's of records, the best thing will be add a text field to the table. when you assign a value to dataformula field, convert it into text and assign it to text field. so in code you can filter on this text field and modify all records.

Can you please give me more details about how to proceed.

I just want to update a field 'Period' of datatype DateFormula from 1D to 2D.

Thanks
Liizz

mohana_cse06

Simply run the table from Object designer
Place the Cursor on field which you want to modify. (in your case it is Period)
Select Edit-->Replace (it will open Period - Replace window)
Enter 1D in "Find What"
Enter 2D in "Replace With"
Click "Replace All"