I am running FMP-9 on a iMac (running snow leopard).
I have a database of over 70,000 records. Records are sorted by date and julian date. I have created a layout when you insert a julian date and it gives you another date (for example, 1,000 days in the past). I would like to tie records to the new date. How do I do this?
For clarity, today (7/20/2011) is 2,455,763. I want to have the program show what date it is 1,000 days in the past. In this case, it would be 10/23/2008).