dBase Expression in lookup.ini

[Calvertfan]

Hello

I have an expression field in Goldmine that displays a date based on the values in two other fields, that I would like to store the date properly, as opposed to just displaying the result on the screen. It would seem lookup.ini is the way to go, but I can't seem to get it to accept my expression.
The expression field is currently:-
WDATE(CTOD(STR(Day(contact2->uindate))+"/"+STR(Month(contact2->uindate))+"/"+STR((Year(contact2->uindate)+VAL(contact1->secr)),0)

This is taking the date help in CONTACT2->UINDATE, and then adding a number of years to it based on the value held in SECR.
Now I've tried putting this into lookup.ini, so that I have a
[UOUTDATE]
otherwise=&WDATE(CTOD(STR(Day(contact2->uindate))+"/"+STR(Month(contact2->uindate))+"/"+STR((Year(contact2->uindate)+VAL(contact1->secr)),0)


but this doesn't work. Any help would be greatfully received!

 

[goner]

why not use DTOC(contact2->uindate)

Doug Castell
Castell Computers

http://www.castellcomputers.com