DateField - 1000 will return a date 1000 days earlier.
Get ( CurrentDate ) - 1000 will return a date 1000 days ago.
Thank you for your reply. I can use the "current date" solution for another problem.
However, I have the "date field - 1000" working. I need to connect to the record associated with the "date - 1000".
Once again, I apologize, my not have asked the question correctly. I have a database of histroical events. If I input today's date (julian date), I would like to see what event occurred 1000 days ago. The "date - 1000" only brings up the new julian date. How do I connect it to the event?
Thank you again! You have always been great help.
It depens on how you want to bring up that "past event" or events.
You can establish a relationship your julian date field and the "-1000" calculation field:
Table::JulianDate = Table 2::JulianLess1000
Then you can add fields from Table 2 to your your layout or use a portal to Table 2. (Table 2 can be a different table or a 2nd occurrence of the same table and this will work.)
You can also use that calculated value in a script to perform a find to bring up the records with this 1000 days ago date.