Get ( CurrentDate ) - 10000
that calculates the date of 10000 days ago.
Such a calculation should also be set in Storage Options checked 'Do Not store calculation results' so it updates as the current date changes.
If today's number is: 2,455,509, the 01/01/0001 ( first date that FileMaker recognizes ) was 1,721,426.
So today you can go back for a maximus of 734,083 days.
Try this unstored calculation, result date:
Get ( CurrentDate ) - YourDaysNumberField > 0 ; Get ( CurrentDate ) - YourDaysNumberField
Thank you everyone for your response. However, I must have missed something along the way. I cannot find a "Get" command.
Is this a script operation or something else?
(For me anyway), not all 'Get' functions appear in the view by all functions by name list, try viewing by "Get" functions only or by all functions by type
And if your version is prior to 7, look for Status ( ) instead of Get(). And it is a function, which can be used either in calculations or in calculations within script-steps such as Set Field, Insert Calculated Result and more.
Thank you everyone again! You pointed me in the right direction. I changed the field to a"calculation" and it worked just the way you said it world.
This forum is the best!