Advanced Functions available in Writer tables and Fields?
Posted: Thu Nov 12, 2015 12:52 am
Hello Everyone!
I am currently making a template lease for use with my rental properties. I want to be able to enter a Move In date and the number of months the future tenant wants, and I want the document to automatically calculate how much is owed for the entirety of the lease as well as an end date that is rounded down to the first of the month. I also want the ability to put in the Tenants DOB, and automatically calculate their age.
I have a table that is imbedded in my template, but it doesn't seem like calc functions such as NOW(), YEARS() and FLOOR() are available inside the table.
Can anyone clarify? Are the advanced functions in calc available inside a table in writer? If so, can these ALSO be used in fields in writer? I would like to not have to use tables if I can avoid it, I would also not want to link to external sources (SQL,Calc) either.
I am currently making a template lease for use with my rental properties. I want to be able to enter a Move In date and the number of months the future tenant wants, and I want the document to automatically calculate how much is owed for the entirety of the lease as well as an end date that is rounded down to the first of the month. I also want the ability to put in the Tenants DOB, and automatically calculate their age.
I have a table that is imbedded in my template, but it doesn't seem like calc functions such as NOW(), YEARS() and FLOOR() are available inside the table.
Can anyone clarify? Are the advanced functions in calc available inside a table in writer? If so, can these ALSO be used in fields in writer? I would like to not have to use tables if I can avoid it, I would also not want to link to external sources (SQL,Calc) either.