>Looks like I and Larry were too quick in our first suggestion. Sergey is right.
>
>So, use the fixed date and Bintoc function, e.g.
>BankCode+bintoc(date(2001,12,31)-ValueDate))
Nadya,
Well, we're unfortunately not out of the woods yet. :(
When we implement the BINTOC in the tag, we're encountering some strange behaviour. If we browse the table in the IDE with that tag order set, the record order is exactly what we expect. However, if we try to seek a record using the same syntax as the key expression it will always fail.
Is there something about creating an expression with BINTOC that's causing a problem when trying to look up the record?
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer