At the office we have a calculation that uses the today function:
case(isempty(date_payment) and paymdate<today;1).
On my computer at home this works like a charm but at the office, where we work with Filemaker Server, it doesn't?!
What did I check on the office computer?
The date on the office's computer is correct and Filemaker has updated the indexes until today.
Why o why isn't this today calculation working? How can I force it to recalculate today's date?
Help is very much appreciated.