General information
Category:
Coding, syntax & commands
Hi,
Those brackets! of course you are correct. Please note it is 23:39 in Amsterdam. Anyhow your solution:
INDEX ON IIF(empty(Field2), Field1,Field2) + IIF(EMPTY(field2),FIELD2,DTOS(CTOD(field3))) TAG mytag
results in:
abcd " " number1
efgh abcd 31/03/2008
fghi abcd 01/03/2008
hiij bcde 18/05/2008
ghij bcde 11/05/2008
bcde " " number2
so need a little bit fineturnig 2morrow 1stthing!
Thanks sofar,
Bye,
Koen
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only