Trying to index a Calculated field

Hi
I am trying to index a calculated field but to no success.
To be exact. I am returning a Day [Day(log:DOB] from a (DOB) ‘Date of birth’ field..
How can I create an index using this “day” field?

Thanking You in advance

Is this a Clarion question or a database question? And if it is a database question, which database?

if I am understanding you properly you will have a Day field in your table and a trigger in the dct on add and change to calculate it “Day(log:DOB)”

then just have your key on the day field.

If you are using a database, as Jon asks, presumably it would be different and you wouldn’t need the client-side trigger.

cheers

Geoff R